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=" & 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
------------------------------
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
      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'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
        ------------------------------