I'm trying to create a workflow that, based on a lookup of a particular company name, will email respective employees in one email. Basically, in the following table, if “ABC CORP” were the key lookup, I would like to assign in a template field and email “ali@email.com”, “jennifer@email.com” and “steven@email.com” in one email. Right now, my workflow is only emailing “steven@email.com." For some reason it will not allow for multiple entries (or email addresses) in the “To:” field.
Lookup table:
Company Email Address
ABC CORP |
|
ABC CORP |
|
ABC CORP |
|
XYZ CORP |
|
XYZ CORP |
And my workflow:
Guidance would be greatly appreciated!