Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago

Creating a new outlook email, and including a link to a file attachment field

I've found a lot of threads on creating a new outlook email, but not sure if I have seen this exact question asked (or if so, I got lost in the rabbit hole of threads). When using the "mailto:" com...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
You can include a URL formula field in the body

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0"

Where 99 gets replaced with the fid of the file attachment field.

I believe that the email clients like gmail and Outlook at the recipient end will see the link and make it a hyperlink. 
 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago
Thanks Mark I'll give it a try. Right now I can't get my email code to produce the subject or body. Can you tell what my mistake is?

var text Subject = "This is the Subject";

var text Body = "This is the body";

//var text Email = "mailto:" & "" & "mtamoush@gmail.com" & "\n" & "?subject=" & $subject & " &body=" & $Body &"";
var text Email = "mailto:"&""&"mtamoush@gmail.com"&"\n"&"?subject="&"\n"&URLEncode($Subject) &""&"&body="&URLEncode($Body)&"";


"<a href=" & $Email & ">" & "Send Email Test" & "</a>"

------------------------------
Mike Tamoush
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    You are building a URL need to travel through the vagaries of the Internet. That means that you need to use URLEncode for any characters which are not A-Z or 0-9 and that means that \n is illegal.  

    var text Email = "mailto:mtamoush@gmail.com"
    & "?subject=" & URLEncode($Subject)
    & "&body=" &URLEncode($Body);


    "<a href=" & $Email & ">" & "Send Email Test" & "</a>"



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    4 years ago
    Awww so simple. Worked like a charm. Thanks!

    ------------------------------
    Mike Tamoush
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      4 years ago
      Last question - you know how to create a line break in the body? I didn't have luck with %0D%0A unless I am using it wrong?

      var text Body =
      "Please process the following New Subcontract Request. Details and a link to the request form are found below."
      & "%0D%0A"
      & "Service Order: " & [SO #]
      & "%0D%0A"
      & "Project ID: " & [Project ID]

      ------------------------------
      Mike Tamoush
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        A line break is

        & "%0A%0A"

        I'm pretty sure tis the same as URLEncode ("\n\n")

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------