Hey All - what’s the best way to send an email to multiple (dynamic) email addresses from an entity record (in a single email)? Currently we send out remittance emails for new outgoing bill payments. I can easily use the Send To Vendor > Email to send it to a single email address. I setup a custom free-form text field on the vendor record so that add’l email addresses can be cc’d. This requires the emails to be entered as a comma-separated list with no spaces, though which is hard to enforce a user to abide by. So what are trying to achieve for example is if vendor 1 has

E-mail

= vendor1@vendor.com and

Email Addresses to be CC'd on Remittances

= vendor1a@vendor.com,vendor1b@vendor.com then we would send a single email with

To

= vendor1@vendor.com and

CC

= vendor1a@vendor.com,vendor1b@vendor.com

I have seen it where you put in complicated logic in a workflow to populate the email address field with the commas for each of the users and store each email in a separate field - but it is a lot of work. Little bit more enforceable than trusting employees to enter it in correctly

hmm yeah that seems like quite a bit of work

you can create saved search alerts that fire where data doesn't follow the format as requested in the plain text field...but trying to use regex for valid email addresses is an exercise doomed to failure - be prepared for some manual error handling

cool, comma-delimited free-form text sounds like the easiest