Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
5 years ago

mailto link not posting the body into a new email

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=" ...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------
IvanWeiss's avatar
IvanWeiss
Qrew Captain
5 years ago
In fact I tried cutting the entire body and just typing the word "test" without quotes in there and the button still do not work.  When I remove the &body from the mailto statement the button works right.

It is a multi-line text field

------------------------------
Ivan Weiss
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Are you saying that it only fails on this  record?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      5 years ago
      Correct, other records work fine.

      ------------------------------
      Ivan Weiss
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        well if the Body is not the culprit, the what's in the other field must be.



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