Gather the Data make CSV and Send an Email

[Gagan_Chaudhari (Gagan)]

Hello,

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 rahul@gmail.com

Any help or idea would be appreciated.

Thanks

[Lak_Ui (Lakshmi)]

can you share both the excel files

[Gagan_Chaudhari (Gagan)]

Sample Files
MasterEmails.xlsx (9.4 KB)
ReportData.xlsx (8.8 KB)
a

[Lak_Ui (Lakshmi)]

Do you want to send mail in table format?

[Gagan_Chaudhari (Gagan)]

I want to make an CSV of same Person’s Data and Send Email with that CSV file as an Attachment.

[Anas_Pv]

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

[Veera_Raj (Veeraraj Sethuraman)]

in send mail activity there property for attachment give the path of csv file and send

[Gagan_Chaudhari (Gagan)]

Can you please provide a sample sequence file.

Thanks

[Eric_Wong_Test (Eric Wong)]

Mail.xaml (13.9 KB)

[ushu (Usha kiranmai)]

Hello @Gagan_Chaudhari Please refer attached workflow

Example.zip (22.2 KB)

Output
It has created csv files for the repeated names