Forum Discussion

Qrew Trainee

2 years ago

URL Formula, "mailto:" &

I've built a formula that allows us to push a button and it extracts information from quickbase and throws it in an editable email for us to send through our outlook. I was wondering if there is...

Qrew Elite

2 years ago

You can also look into Juiced Technologies Courier Add On. It won't open up an editable email, but can create and send emails with attachments. I have found it useful for a number of different use cases we have.

------------------------------
Mike Tamoush
------------------------------

Qrew Trainee

2 years ago

That sounds useful. Can you share the code?

------------------------------
Eric Fixler
EFC
------------------------------

MikeTamoush
Qrew Elite
2 years ago
Eric,

I am by no means an expert on the MailTo syntax, but I do have notes I saved for myself. This should get you going. The following should be in a formula rich text field:

var text Subject =
    "Enter Subject Line Text here " & [Add Fields If Desired] ;

var text File = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e57/v0"; //use this if you want to include a file link

var text Body =
     URLEncode("Enter text for body here")
    & "%0A%0A"   //THIS IS A LINE BREAK PLUS SKIPS A LINE
    & URLEncode("Company Name: " & [Company Name]) // EXAMPLE OF HOW TO ENTER TEXT AND A FIELD
    & "%0D%0A"   //THIS IS A LINE BREAK, DOES NOT SKIP A LINE
    & URLEncode("File Link: " & $File)
    & "%0A%0A"
    & URLEncode("QuickBase Link: " & [Link Field]));

var text Email = "mailto:Fakename@fakeemail.com" //WHAT EMAILS ARE IN THE TO LINE
& "?cc=fakenametwo@fakeemail.com" //EMAILS IN THE CC LINE
& "&subject=" & URLEncode($Subject)    //NOTE: If you remove the cc line, then add a ? ie: & "?subject=" & URLEncode($Subject)
& "&body=" & $Body;

//Final Note: The first line after mail to should have a '?' and NO "&". This indicates everything following is being set.


"<a href="
& $Email
& ">" & "Create Email" & "</a>"

------------------------------
Mike Tamoush
------------------------------