How to send alerts to dynamic list of people.

RebFlo

Hello,

I would like to set up automation to send an alert to 4 different recipients. 1 of them will always be the same, but the other 3 recipients will always change. These 3 emails are already entered in other columns on the sheet. Is there any way to pull in those 3 email addresses from the sheet and include the 1 constant email address into a contact list automatically, like with a formula? All 4 will need to receive the same email at the same time. I know we can't CC people, but any ideas are appreciated.

Paul Newcome

You could create another contact column in the sheet and then use a column formula to output the 4th constant email.

="email@address.com"