When trying to put the contents of an HTML email into a field or variable or something like that for the Email Body, inevitably the HTML code is going to contain quotation marks that will confuse Filemaker into looking for operators that actually aren't needed. Is there an easy way to handle this or do I have to go through the HTML and markup each occurrence of a quotation mark with a backslash or forward slash (I don't remember exactly how).

Any tips would be much appreciated.

Thanks.

There should be no issue with storing the HTML in a text field. As long as you reference the field itself (as opposed to manually typing in HTML) in a calculation you should have no problem there either. Try this out to make sure but you shouldn't have to escape anything. Let me know if you have trouble getting it to work and specifically what the issue is.

If you happen to be creating the HTML (with quotes) not in field, but in a variable or in the calc engine directly...

you can 'escape' the quotes with ""

"<input type="text" name="fieldname" value="" & currentfieldName & "">"

I tend to like creating the HTML "normally" in BBEdit and then add the "" (with find/replace) just before quoting the whole thing and pasting in the dialog. to use field values, you end the quote, add the field name & start the quote again, as above.

HTH,

Beverly

The find/replace solution works great. Thank you!

I am having an issue with referencing the field directly.

 

If I have this in the body (using EmailSetBody(Table::Field, "html")):

 

<a href="www.google.com">Google</a>

 

The email has a nice link, but it goes to:

 

http://xn--www-6o0a.google.xn--com-9o0a/

 

Any thoughts?

Seems a little silly, but I took out the quotes and the link works fine.

 

<a href=www.google.com>Google</a>