Forum Discussion

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

Icon for Qrew Legend rank

Qrew 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
Qrew Captain
5 years ago
I gave that a shot and no luck. Oddly enough, on my mac it drafts the email but the body is blank. On my PC it does not even draft the email. I did confirm when I remove body from the mailto statement it works fine. So it is clearly something in this body that is doing it....

------------------------------
Ivan Weiss
------------------------------
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
  Qrew 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
    Qrew Captain
    5 years ago
    Correct, other records work fine.
    
    ------------------------------
    Ivan Weiss
    ------------------------------