Skip to main content
Solved

Using button to email multiple email addresses and a cc field

S
Forum|alt.badge.img+4

Hi all,
I’m trying to email multiple people in a record with a button field. I’ve almost got it but when I can manage to get both email addresses to show up, they are joined together and the second email address is a bit off using a % instead of the @ (although I think if I could separate them it would resolve).

This is what I’m using:
“mailto:”& ENCODE_URL_COMPONENT(ARRAYJOIN({Seller 1 email})& ENCODE_URL_COMPONENT(ARRAYJOIN({Seller 2 Email}))) & “?subject=” & Property

I’m trying to paste an image but I can’t see in this email draft…

How do I get the addresses to be separated? I’ve tried all I know how to do, quotes, commas, semi colons…I’m at a loss.

The other piece is the cc portion which I’ve only seen gmail examples and they aren’t working in a generic email.

Thanks in advance for any help!!

Best answer by TheTimeSavingCo

Hi Sally, try this:

"mailto:" & 
ENCODE_URL_COMPONENT({Seller 1}) & 
"," & 
ENCODE_URL_COMPONENT({Seller 2}) & 
"?subject=" & 
ENCODE_URL_COMPONENT({Property Name})

For the CC bit, try this one:

"mailto:" & 
ENCODE_URL_COMPONENT({Seller 1}) & 
"," & 
ENCODE_URL_COMPONENT({Seller 2}) & 
"?subject=" & 
ENCODE_URL_COMPONENT({Property Name}) & 
"&cc=" & 
ENCODE_URL_COMPONENT({CC Email})

And I’ve set it up here for you to check out.

View original
Did this topic help you find an answer to your question?

4 replies

TheTimeSavingCo
Forum|alt.badge.img+28

Hi Sally, try this:

"mailto:" & 
ENCODE_URL_COMPONENT({Seller 1}) & 
"," & 
ENCODE_URL_COMPONENT({Seller 2}) & 
"?subject=" & 
ENCODE_URL_COMPONENT({Property Name})

For the CC bit, try this one:

"mailto:" & 
ENCODE_URL_COMPONENT({Seller 1}) & 
"," & 
ENCODE_URL_COMPONENT({Seller 2}) & 
"?subject=" & 
ENCODE_URL_COMPONENT({Property Name}) & 
"&cc=" & 
ENCODE_URL_COMPONENT({CC Email})

And I’ve set it up here for you to check out.

Adam, Consultant @ thetimesaving.company
S
C
2 people like this
  • S
    Sally_Schueler
  • C
    Cynthia_C
S
Forum|alt.badge.img+4
  • Sally_Schueler
  • Author
  • New Participant
  • 3 replies
  • June 26, 2022
TheTimeSavingCo wrote:

Hi Sally, try this:

"mailto:" & 
ENCODE_URL_COMPONENT({Seller 1}) & 
"," & 
ENCODE_URL_COMPONENT({Seller 2}) & 
"?subject=" & 
ENCODE_URL_COMPONENT({Property Name})

For the CC bit, try this one:

"mailto:" & 
ENCODE_URL_COMPONENT({Seller 1}) & 
"," & 
ENCODE_URL_COMPONENT({Seller 2}) & 
"?subject=" & 
ENCODE_URL_COMPONENT({Property Name}) & 
"&cc=" & 
ENCODE_URL_COMPONENT({CC Email})

And I’ve set it up here for you to check out.


Awesome!! Thank you so much! I still had to use the arrayjoin function since I’m using lookup fields (I probably didn’t mention that), it wouldn’t work without it, but overall, this did the trick! After I posted this, I tried a whole host of ways to get that separator in and I just couldn’t get it to work. Can’t thank you enough for your time!

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo
ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8858 replies
  • June 26, 2022
Sally_Schueler wrote:

Awesome!! Thank you so much! I still had to use the arrayjoin function since I’m using lookup fields (I probably didn’t mention that), it wouldn’t work without it, but overall, this did the trick! After I posted this, I tried a whole host of ways to get that separator in and I just couldn’t get it to work. Can’t thank you enough for your time!


FYI: The other way of turning a lookup field from an array into a string is to just append empty quotation marks after the field like this:

{Lookup Field} & ""

H
S
2 people like this
  • H
    Helen_Fletcher
  • S
    Sally_Schueler
S
Forum|alt.badge.img+4
  • Sally_Schueler
  • Author
  • New Participant
  • 3 replies
  • June 26, 2022
ScottWorld wrote:

FYI: The other way of turning a lookup field from an array into a string is to just append empty quotation marks after the field like this:

{Lookup Field} & ""


Thank you!! Super helpful - adding this to my notes on formulas! I just tried it and it definitely neatens things up. :thumbs_up: :thumbs_up:

ScottWorld
1 person likes this
  • ScottWorld
    ScottWorld

Reply


Most helpful members this week

Terms & Conditions