Skip to main content

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

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.

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!

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} & ""

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:

Reply


Terms & Conditions