I have 2 Excel files (Report.xlsx & MasterEmails.xlsx).
Report.xlsx contains some Data and column “name” has Persons name.
MasterEmails.xlsx contains Email ID of those person.
I want to send Email containing Data to the specific user using the Email ID from MasterEmail.xlsx.
Sending Email to : Rahul
Email ID should be : firstname.lastname@example.org
Data is :
ID : 102
Name : Rahul
Department : IT
Salary : 230000
Any help or idea would be appreciated .
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
You can use send outlook maill message
You can put value
To - Current row(“EmailID”). Tostring
Try like this
- Read 1st excel-Dtout
- Read 2nd excel-Dtout2
- Take one for each row in data table pass the dtout
- Take one more for each row and pass the dtout2
- Take one if condition and pass the expression like this
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
You can follow this workflow
Sample.zip (15.6 KB)
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.
you can use this one
Test.xaml (18.2 KB)
Thanks you for the quick response, But I need a format like
Use this one
it will work
Test.xaml (20.1 KB)
if you are getting expected output,
Please close this thread with mark the Appropriate Solution
so that it will help to others
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?