Extracting first email in a field with multiple em...

[Sally_Schueler]

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

[TheTimeSavingCo · Accepted solution]

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.

[Sally_Schueler]

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!

[ScottWorld]

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

[Sally_Schueler]

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: