Send Dynamic Emails From Config File

Hi all,

I have a config file with some names and emails. What I want to do is iterate through the file, and send an email to each person. I’ll have the contact names inserted into an email template. I was able to do this successfully but only when I merged all the data into the same columns (for example I put all emails in one column, and then all contact names in one column separated with “and”. The company will be in the subject line.

Here is an example of the first email I would want to send:

Subject Line: CCG
To: john@ccg.com;bill@ccg.com

Dear John and Bill,
(email template here)

image

Any ideas how to do this?