Creating mass emails with data from excel to populate

Help
1

Hello,

Every quarter I send out a large amount of emails, about 50-60. Each email is addressed to someone different as well as who is copied on that email. The body of the email is fairly consistent however. I have an excel spreadsheet that contains all of my contacts in it. Is there a way to create a workflow to auto populate emails for me to review before sending using my data from excel?

Thank you,

2

@connor.chapin

It can send the mail automatically but there is no way to review before sending the data. You can check in the excel itself you can test it with test-data.

There is one thing you can do. You can send the mail to yourself then review it like how it will look, data is correct and in order then you can initialize the code which will send the data to corresponding members .

Hope it will help you.

Best!!
Anmol