How to send emails to multiple addresses in Workflow

[Ray]

I have a workflow rule that sends an email to customers when changes are made or new records are added to a table. In some cases my customers would like this message to be sent to more than one email address. I’ve tried to add comma separated addresses to the field but that does not work. Is there an easy workaround without making a table dedicated to emails for each customer?

Thank you
Ray

[Marc_Dillon]

What exactly did you try? Here’s a screenshot showing 3 possible options. I haven’t tested, but I’m pretty sure at least one should work.

[Ray]

I added the email addresses to the spreadsheet column and referenced it in the routine with [CustomerName].[CustEmail] in the To space.

[Marc_Dillon · Accepted solution]

Maybe try this then:

SPLIT( [CustomerName].[CustEmail] , “,” )

[Ray]

That works - thanks Marc. Much appreciated

Be Safe
Ray

[Ray]

Perhaps I can rewrite the entry as such:

List([CustomerName].[CustEmail])