Multiple email addresses in one field

[Limi]

Hi all,

I have an automation that needs to send an email to several people in one organization (the record is the organization). Is it possible to add more than one email address into the same field (Email? text?) rather than me creating 5 different fields that are all columns? 

[Ben_Young1]

Hey @Limi! 

The straight forward method that falls along the same lines as best practices would be to have your email address data live in another table.
Suppose we have a Sales object and a Contacts object.

We need to send an email relating to the Sale record to all the linked Contact records.
Since the email addresses of individual contacts is relevant to the Contact record, you'd simply link your contacts to the related sales records.
Now, you'll be able to quickly automate the process of grabbing all the email addresses of your contacts by leveraging the Find records automation action.
Bringing it all together, you'd just plug in the list of all the email addresses in your automation and you're ready to roll!

[kuovonne]

An email field is essentially a single line text field. You can type multiple email address in it, separated with commas. 

[edg]

This doesn't seem to be true

[kkubik7]

kuovonne, an email field is not a text field. It is whatever you want it to be. Use toString() to group the emails together once you have passed them to an array.

kkubik7

[kkubik7]

Ben, 

I agree with email addresses living in own table. run a select statement to get them to an array then use something like toString() to move them into string that can be used to populate email receipient field.

NOTE: Please, please, please NEVER add more than one email address to a field. You are asking for a world of trouble.

Kim