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])
&"&bcc=email@email.com"
// 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
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])
&"&bcc=email@email.com"
// 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
-
132 Points
Posted 1 year ago
QuickBaseCoach App Dev./Training, Champion
-
52,928 Points
QuickBaseCoach App Dev./Training, Champion
-
52,928 Points
Kim
var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_47=" & ToText(Today());
var text URLTWO=
"MailTo:"& URLEncode([Store No - Contact Main Email])
&"?subject=" & "Store " & [Store No] & " POS Checkout Site Readiness Survey and Install Guides / Guides Sondage de préparation du site et installation pour les caisses enregistreuses"
& "&cc="& URLEncode([Store No - Contact Secondary Email])
& "&bcc=checkout@cantire.com;RSSECLEVEL@cantire.com"
& "&from:=checkout@cantire.com"
Kim
Ⲇanom the ultimate (Dan Diebolt), Champion
Kim
QuickBaseCoach App Dev./Training, Champion
Try this
var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_47=" & ToText(Today());
var text URLTWO=
"MailTo:"& URLEncode([Store No - Contact Main Email])
&"?subject=" & URLEncode("Store " & [Store No] & " POS Checkout Site Readiness Survey and Install Guides / Guides Sondage de préparation du site et installation pour les caisses enregistreuses")
& "&cc="& URLEncode([Store No - Contact Secondary Email])
& "&bcc=checkout@cantire.com;RSSECLEVEL@cantire.com"
You will see that I URLEncoded the Subject line. I removed the from.
I tested it and that worked - almost. The issue will be the é in préparation. Quick Base is not great at handling alternative character sets. So you may have to drop the é and go with e to get that to work.
Sometimes in French it is easier to get away with dropping the accents if the words are in caps. ie you may need to ask your French support staff which is the least worst, just going with e or making that whole subject line in UPPER CASE.
If you need to remind the users to change the "from" manually in Outlook, then you can add some instructions in the body like
& "&body="& URLEncode("attention: remember to remove this note and change the from to xxxxxx and remember to attach the readiness Survey")