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 create an CSV file of the Data of same person name and send to that Particular Person’s Email ID.
If ‘Rahul’ name come twice then it should merge the Data of Rahul and send to email@example.com
Any help or idea would be appreciated.
can you share both the excel files
MasterEmails.xlsx (9.4 KB)
ReportData.xlsx (8.8 KB)
Do you want to send mail in table format?
I want to make an CSV of same Person’s Data and Send Email with that CSV file as an Attachment.
Read the data file to a datatable say dt_data and MasterEmails to a table say dt_email
For each row in dt_email
Filter data table dt_data with name in dt_email
(This will filter only results for that name)
Save the filtered dt to a temporary datable, write this to a csv and send mail to dt_email EmailId column value
in send mail activity there property for attachment give the path of csv file and send
Can you please provide a sample sequence file.
Hello @Gagan_Chaudhari Please refer attached workflow
Example.zip (22.2 KB)
It has created csv files for the repeated names