Creating an email for each row of data in excel sheet

Help Studio
, ,
1

Hi there. I am really struggling to figure which is the best way to create an email, and populate the email address, subject and body, from a set of data in excel.

I need the solution to create a separate email for each row in the data set. I know this can be easily done, so forgive me for asking such a simple thing, but i have only just completed my training and am struggling. I have looked on the forum but all the similar solutions are old.

Below is an example of the data table which i want to use, thank you in advance for your help :slight_smile:

|Email|Subject|Body|

|—|—|—|

|Email Distribution List|Name|Text|

|joebloggs@test.com|Investor 1|Hi thank you for joining the mailing list|

|jane@test.com|Investor 2|Hi thank you for joining the mailing list|

|john@test.com|Investor 3|Hi thank you for joining the mailing list|

|chirs@test.com|Investor 4|Hi thank you for joining the mailing list|

2

@jason.rosato

  1. use excel file
  2. for each row in excel
  3. send email inside for each with To field as {currentrow("Email Distribution List").ToString}, Subject and body similarly currentrow("Text").ToString …

this would send email for each row

cheers

3

Hi @jason.rosato

  1. use read range to load the excel data into a datatable, for example named emailTable
  2. use for each row in datatable to loop through each row in emailTable
  3. inside the loop, add a send outlook mail message / Other mail activity
  4. set the ‘to’ field to row(“Email”).toString
  5. set the ‘subject’ field to row(“Subject”).toString
  6. set the ‘body’ field to row(“Body”).toString
  7. run the workflow to send separate emails for each row in the excel file

Happy Automation