About Mails Body

Help
, ,
1

Hi EveryOne,
I Have Excel File With Two Columns “Name”,“Mail_Id”.Am Sending Mails Like Dear “Name” .Here i want to Iterate Name EveryTime who is the Mails Holders and using Text File for Body thats why am asking.Please Help Me.
Thanks In Advance
Krishnareddy

2

@krishnareddy,

Here are some steps to do:

  1. Read the entire excel to datatable
  2. use for each row to iterate through the rows and use row(“Name”).tostring to get the name in each row

I don’t understand this part. Can you elaborate?

3

@HareeshMR Thanks For ur response
I have Text file for body i directly giving the variable name in body instead of writing in body lable.
I have done Both 1 and 2 what u have mentioned.
Thanks

4

You want to read the text file using the name of a person in the excel and paste the text file data to body?

Am I right?
@krishnareddy

5

@HareeshMR Yes Bro…

6

@krishnareddy,

As we are getting the name of the person , just store in a string variable and use Read text file activity to read the text and store the output content in a variable. Just pass the content variable to the mail body. Thats as simple as this.

7

@HareeshMR
Here The Name will be Change everytime in Body Like “Dear Krishna”,“Dear Hareesh”.How can we Change that For Each Time.

8

Yes, Do the entire thing within for loop so that the variable is stored with new name everytime and the text will also be replaced with the variable value @krishnareddy