Help

Using button to email multiple email addresses and a cc field

Topic Labels: Formulas
Solved
Jump to Solution
208 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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…

image

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.

image

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!!

1 Solution

Accepted Solutions

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.

See Solution in Thread

4 Replies 4

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!

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:

Labels