CloudMail and HTML Fields

[Darren G]

I’m trying to make our CloudMail emails a little easier to edit and send and I’ve setup my CMQueueMessage Function to look like below:

CMQueueMessage(
Bulk Emails::Email Body;
"";
Bulk Emails::Email Subject;
Bulk Emails::Email From Address;
Bulk Emails::Email Title) = “ERROR"

I then have a table in FileMaker with Records for all of our emails and I basically tell FM to use the current record to populate the CMQueueMessage

The issue I’m having is putting the HTML code in for the Email Body

Here is an example of what is currently in my Email Body field:

Table::First Name & ",<p>

Congratulations on your amazing efforts this year" & Table::First Name & "!<p>

Wishing you a happy holidays and the best for health, happiness and success in 2019!<p>

Yours truly,<p>

Darren"

Everything looks perfect after the first “ in the email up to the Table::First Name after sending with CloudMail but it is not filling in the information from the Table::First Name field but instead the email shows:

Table::First Name & “

Congratulations on your amazing efforts! & Table::First Name & "!

Wishing you a happy holidays and the best for health, happiness and success in 2019!

Yours truly,

Darren

 

If I put in the CMQueueMessage Function where it says Bulk Emails::Email Body the HTML code above everything works perfectly but once I change it to a FileMaker field it doesn’t work properly.  I thought this would work because this was the exact html code that was I used in the CMQueueMessage Function rather than the FileMaker Field, but I was hoping to move all of these HTML messages into records to better edit and manage our bulk emails.

Any suggestions?