Using information in excel to send emails

Help Activities
, ,
1

Hello New user here! I’m trying to compare two sheets in an excel file , sheet1 contains emails and subjects(which were extracted from emails) while sheet2 contains subjects and their replies, what i want to do is match sheet1 and sheet2 and use the email in sheet1 as the TO address and the replies in sheet2 as the body.
I’ve been trying different activities but i keep messing up, any help is greatly appreciated

2

Hey @irshad

Kindly use Join Data Table activity by reading the excel data into the Data Table using Read Range.

Thanks
#nK

3

Hello @irshad

You can use the attached workflow. In the Input folder modify the excel files with your data. I have used a left join. You can change it as per your requirement. So you will get a new joined Datatable and you can use that to sent the email.

ExcelAutomationDemo1.zip (2.0 MB)

image
image543×688 19.5 KB

image
image568×695 18.5 KB

4

@irshad use Join data table or Query. Use Connect activity for Excel as DB