How to match Employee Name and Project Code in a daily report and e-mail relevant data to him

I have Daily Report get generated and Project Code varies and want to map the relevant employee Name and e-mail address to send that particular information (Sample Output) daily to relevant e-mail address.
Please refer to attached sheet.
thanks for your help in advance.
Demo.xlsx (19.2 KB)


You can use Read Range activity to read the excel sheet and pass below for reading the particular sheet



It will change dynamically according the current date

Declare a variable let’s say it’s a Dt1

Now use Read Range activity and declare a variable let’s say Dt2


Now use Join Datatables activity using Department Code as it’s common for both sheets


Now you can use Filter Datatable and output your required columns

You can use Write Range activity to write back to excel

Hope this will help you