mailto link not posting the body into a new email

Question

Hi everyone,I have a formula URL button with the following code:"mailto:" & [External Email Addresses] & "?subject=" & URLEncode([Email Subject]) & "&body=" & URLEncode([Email Body]) & "&cc=" & URLEncode([Internal Email List])The intent is to take a draft of an email written in Quick Base so that we retain a copy of the email attached to our project and when we click on the submit email button it populates the email in Outlook.  For some reason in this one particular email the body is coming in blank.  The screenshot is the form of the record, showing everything filled out properly.I get the To, CC, and Subject properly.  Body is blank------------------------------Ivan Weiss------------------------------

MarkShnierYou · Answer

It is likely the single quote in Hi Jimmy hope you're .....

Try this

var text Body = SearchAndReplace([Body],"'",""); // change the single quote to null

"mailto:" & [External Email Addresses] & "?subject=" & URLEncode([Email Subject]) & "&body=" & URLEncode($Body) & "&cc=" & URLEncode([Internal Email List])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community