URL Mail To help

Question

I've got a URL formula field that needs to open a draft email with the names [Combined Text Email] and subject  [Meeting Date] filled in. So far I've gotten the open email part but can't seem to get the rest right. Here is my formula:
var text Email = "MailTo:" &amp;([Combined Text Email]);

var text Subject =  &amp;(ToText([Meeting Date]))
&amp;"?Subject=" &amp; "($Subject)";

var text URL = "&lt;a href='https://mail.google.com/mail/u/0/#inbox?compose=DfGhPkmsgkdqdlggxFvglVRkZfcTHWhDXKQCcvMpFWgcvJwfvqpmJnlSrZSPjWFGxGpXhLsdMmJvpJzlxmXGPBWlJlWPCkgbXhKxmtsCqdDmhmTpzpjtsxxB'&gt;Email Contacts&lt;/a&gt;";

$URL &amp; "&amp;rdr="
&amp; URLEncode($Subject)
&amp; URLEncode($Email)​------------------------------Bethany Hudson------------------------------

miketamoush · Answer

This is my cheat sheet for the MailTo command. It's for a rich text button. It will open an email in whatever the default email client is. I do not know the proper code to specify which email client.var text Subject =&nbsp;&nbsp;&nbsp;&nbsp; "Enter Subject Line Text here " &amp; [Add Fields If Desired] ;&nbsp;var text File = URLRoot() &amp; "up/" &amp; Dbid() &amp; "/a/r" &amp; [Record ID#] &amp; "/e57/v0"; //use this if you want to include a file linkvar text Body =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; URLEncode("Enter text for body here")&nbsp;&nbsp;&nbsp; &amp; "%0A%0A"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //THIS IS A LINE BREAK PLUS SKIPS A LINE&nbsp;&nbsp;&nbsp; &amp; URLEncode("Company Name: " &amp; [Company Name]) // EXAMPLE OF HOW TO ENTER TEXT &amp; FIELD&nbsp;&nbsp;&nbsp; &amp; "%0D%0A"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //THIS IS A LINE BREAK, DOES NOT SKIP A LINE&nbsp;&nbsp;&nbsp; &amp; URLEncode("File Link: " &amp; $File)&nbsp;&nbsp;&nbsp; &amp; "%0A%0A"&nbsp;&nbsp;&nbsp; &amp; URLEncode("QuickBase Link: " &amp; [Link toSubcontractor Assignment]));var text Email = "mailto:ThisName@youremail.com" //WHAT EMAILS ARE IN THE TO LINE&amp; "?cc=ThisName@youremail.com"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //WHAT EMAILS ARE IN THE CC LINE&amp; "&amp;subject=" &amp; URLEncode($Subject)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //NOTE: If you remove the cc line, then: &amp; "?subject="&nbsp; (note '?') &amp; "&amp;body=" &amp; $Body;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // The first line after mail to should have a '?' and NO "&amp;". This indicates everything following is being set.&nbsp;&nbsp;"&lt;a href="&nbsp;&amp; $Email&nbsp;&amp; "&gt;" &amp; "Create Email" &amp; "&lt;/a&gt;"------------------------------Mike Tamoush------------------------------

Forum Discussion

URL Mail To help