Compare two columns from 2 different excel files and use the value from the second excel file to send an email

Help Activities
, ,
1

Hi all,

I have one report which will be generated with a column called Buyer name. I have a master excel file with the email ids of all the buyers. I need to lookup the buyer name match them and get the email id and send them an email. How do I do this?

image
image1367×64 63.6 KB

The report excel file looks like this

image

Master email excel file looks like this

1 Like
2

Hi @Harshita_Ramesh

Please see the below attached workflow
Main.xaml (15.0 KB)

3

Hi @sangeethaneelavannan1
Thank you for your response, but I got this error

image
image1592×915 66.7 KB

4

@Harshita_Ramesh check the scope of all variable and set it to main sequence

5

I did but yet it shows the same error

6

@Harshita_Ramesh masterdt should not be null. Please check it has the data and also datatype of email should be string

7

@sangeethaneelavannan1
It gives only one first row email value

8

@Harshita_Ramesh
How many entries are present in the report file?

9

4 Email Id’s in Report file. But it Extracted one Email Id for all Columns.
Screenshot 2022-12-30 072511

10

@sangeethaneelavannan1

What is the value for Index variable?
I see it takes only first row value as shown in picture by @shanmugapriyag

11

@sangeethaneelavannan1

Actually got it I had not declared Index in lookup table Row Index

Thanks for your help

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.