So I tried it again from a different computer just for the fun of it. The same result, except when I switched the body to test this time the mailto worked.
I right now have the following to start stripping out characters I can think of:
var text BodyFirstStrip = SearchAndReplace([Email Body],"'",""); // change the single quote to null
var text BodySecondStrip = SearchAndReplace($BodyFirstStrip,"/","");
"mailto:" & [External Email Addresses] & "?subject=" & URLEncode([Email Subject]) &
"&cc=" & URLEncode([Internal Email List]) &
"&body=" & URLEncode($BodySecondStrip)
Any other thoughts?
------------------------------
Ivan Weiss
------------------------------
Original Message:
Sent: 01-12-2021 16:17
From: Mark Shnier (YQC)
Subject: mailto link not posting the body into a new email
You say on other records it works, but on his record, when you change the body to just one word like "test" it fails?
Just on case, what is the email addresses for the TO and CC and Subject for this record?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 01-12-2021 15:03
From: Ivan Weiss
Subject: mailto link not posting the body into a new email
But if I eliminate the body from the mailto code it works fine. That is why I am pretty sure it is the body and not to, cc, or subject. Without the body those work.
------------------------------
Ivan Weiss
Original Message:
Sent: 01-12-2021 14:41
From: Mark Shnier (YQC)
Subject: mailto link not posting the body into a new email
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
Original Message:
Sent: 01-12-2021 14:22
From: Ivan Weiss
Subject: mailto link not posting the body into a new email
Correct, other records work fine.
------------------------------
Ivan Weiss
Original Message:
Sent: 01-12-2021 13:48
From: Mark Shnier (YQC)
Subject: mailto link not posting the body into a new email
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
Original Message:
Sent: 01-12-2021 12:34
From: Ivan Weiss
Subject: mailto link not posting the body into a new email
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
Original Message:
Sent: 01-12-2021 08:06
From: Mark Shnier (YQC)
Subject: mailto link not posting the body into a new email
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
Original Message:
Sent: 01-12-2021 08:02
From: Ivan Weiss
Subject: 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
------------------------------