Forum Discussion

KimRavizza's avatar
KimRavizza
Qrew Assistant Captain
9 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

Replies have been turned off for this discussion
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 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
      9 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
      9 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.