Reputation: 69
I need to send an E-mail to multiple recipients. In the body of mail, few of the words(around 10 -12) needs to be changed every time, out of 20 lines. These words are available in column A of an excel sheet.
Example
**Body of Email**
Hi all,
Thanks for your email. The data is available from 12th May to 15th May only. Kindly call back after 10th of May.
In this, dates needs to dynamically changed based on a column values in an excel sheet.
Is there any possibility for this?
Upvotes: 0
Views: 1985
Reputation: 11197
You just need to define your variables (or simply take the output from Excel like you have) and then just throw the dynamic content into the variable/field that contains the body of the email, like thus ...
Result
Upvotes: 1