Forum Discussion

KimRavizza's avatar
KimRavizza
Qrew Assistant Captain
8 years ago

Mailto - more than 1 email address in the CC

Here is the top part of the formula I'm using to automate the sending of an email to specific users:

var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_662=" & ToText(Today());

var text URLTWO= 

"MailTo:"& URLEncode([Contact Main Email])
&"&cc="& URLEncode([Contact Secondary Email])
&"&[email protected]"
// the above text invokes the mail client, and creates the TO line
&"?subject=" &  "Store " & [Store No] &  " POS Checkout Site Readiness Survey"

I need to BCC two email addresses. These addresses will always be the same for every email. Is there a way to have two emails in that line? I've tried putting a ; after the first email and then putting the second, but this doesn't seem to work.

While we are at it, is there a way to change the From to a specific email address? I have been having to change that manually to make it come from our project mailbox, rather than my personal email.

Thank you,

Kim
Ask about Quickbase functionality

10 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    The ? is the indicator that the rest of the parameters follow, so it needs to be first.


    "MailTo:"& URLEncode([Contact Main Email])
    & "?subject=" & URLEncode("Store " & [Store No] &  " POS Checkout Site Readiness Survey")

    & "&cc="& URLEncode([Contact Secondary Email])
    & "&[email protected];[email protected]
    • KimRavizza's avatar
      KimRavizza
      Qrew Assistant Captain
      8 years ago
      Thanks Mark. I moved the subject line up and put in the extra email address. When I click on the button it just opens a blank tab. I took out the extra email address and it works fine. Were you able to get this to work with more than one email?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      8 years ago
      I tested this code and it works in Gmail and Outlook as mail clients
      var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#])
       & "&_fid_14=" & ToText(Today());



      var text URLTWO= "mailto:" & "[email protected]"
      & "?subject=" & URLEncode("this is the subject")
      & "&[email protected]"
      & "&[email protected];[email protected]"
      & "&[email protected]";

      $URLONE 

      & "&rdr=" & URLEncode($URLTWO)

      Can you post your code that is not working?  maybe there is an extra space somewhere or a syntax error.