Automatic Email Merge

Can you pull data from an Excel spreadsheet to create email through Email. I will pull the client name, Email address, subject and Body messages from the excel spreadsheet.

Hy @uidonna.jones, yes it can be donne.

Read Excel using the Read Range Activity
Use a For each Row activity to iterate through the rows and fill in your variables
use the send outlook message activity

regards

Yes we can do with below steps,

1.First Read excel with Read Rane
2.Take For each Row in Data table
3.assign with Get Row item for (Email address,subject and Body of the mail)
4.Send mail activity (give all required properties)

Thanks
Latika

Thanks for responding to my post. Is there a tutorial or workflow example I can follow to help me better understand the steps. For instance, I don’t understand the "ForEach row in Enter a VB expression means.

https://youtu.be/3kW8YrzgCPs please check this video.

For each row in Data table activity - looping through multiple rows(https://youtu.be/LFvvQOYZM3E)

Thanks
Latika

1 Like

I was able to do the Email Merge using an Excel spreadsheet. My new question is, how can i send emails from different people from my email. For instance, the From email is in a column in the excel spreadsheet, how do I add that in the Use Outlook Account field?

Hi @uidonna.jones

I have created workflow to send email to multiple recipients reading from excel config file

Hope this will help you.

Thanks
LatikaExcel_Seding Email.zip (33.7 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.