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