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
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.
I added the email addresses to the spreadsheet column and referenced it in the routine with [CustomerName].[CustEmail] in the To space.
Maybe try this then:
SPLIT( [CustomerName].[CustEmail] , “,” )
Perhaps I can rewrite the entry as such:
List([CustomerName].[CustEmail])
That works - thanks Marc. Much appreciated
Be Safe
Ray
