Send Email with Ref to Excel values

Hello,

I have 2 Excel files (Report.xlsx & MasterEmails.xlsx).

Report.xlsx contains some Data and column “name” has Persons name.

SendEmailData

MasterEmails.xlsx contains Email ID of those person.
1SendEmailData

I want to send Email containing Data to the specific user using the Email ID from MasterEmail.xlsx.

Expected :
Sending Email to : Rahul
Email ID should be : rahul@gmail.com

Data is :
ID : 102
Name : Rahul
Department : IT
Salary : 230000

Any help or idea would be appreciated .

Thanks.

Hey,

You can use Read range activity

And then use for each roe

Inside for each row

You can, store the value

Name-currentrow(“name”). To string
Like that you vlcan put
Id
Dept
Salary

You can use send outlook maill message

You can put value

To - Current row(“EmailID”). Tostring

Thanks

Hey!

Try like this

  1. Read 1st excel-Dtout
  2. Read 2nd excel-Dtout2
  3. Take one for each row in data table pass the dtout
  4. Take one more for each row and pass the dtout2
  5. Take one if condition and pass the expression like this
CurrentRow1("Name").ToString.Trim.Equals(CurrentRow2("Name").ToString.Trim)

in Then block take one assign activity

Assign MailBody = "Sending Email to : "+CurrentRow1("Name").ToString.Trim+vbcrlf+"Email ID should be : "+CurrentRow2("EmailID").ToString.Trim+vbcrlf+vbcrlf+"Data is :"+vbcrlf+"Name :"+CurrentRow1("Name").ToString.Trim+vbcrlf+"Department : "+CurrentRow1("Dept").ToString.Trim+vbcrlf+"Salary :"+CurrentRow1("Salary").ToString.Trim

Try this and let me know

Regards,
NaNi

Hey

You can follow this workflow

Sample.zip (15.6 KB)

Thanks

Hey Thanks a lot Buddy,

One more thing, While sending the mail in the Body can we Use the Table Format ?
Need to send the Data in the Table Format.

Hey,

you can use this one
Test.xaml (18.2 KB)

Thanks

Thanks you for the quick response, But I need a format like

Thanks

Hey,

Use this one
it will work
Test.xaml (20.1 KB)

Thanks

Hey @Gagan_Chaudhari,

if you are getting expected output,
Please close this thread with mark the Appropriate Solution
so that it will help to others

Thanks
Rounak

Hey @Rounak_Kumar1 ,

Thanks for the file, actually I tested it Later and It’s giving me error
Create HTML Content: Directory “C:\Users\Downloads.data” doesn’t exist.

Can you provide this file as well?

Thanks.