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?
The report excel file looks like this
Master email excel file looks like this
Please see the below attached workflow
Main.xaml (15.0 KB)
Thank you for your response, but I got this error
@Harshita_Ramesh check the scope of all variable and set it to main sequence
I did but yet it shows the same error
@Harshita_Ramesh masterdt should not be null. Please check it has the data and also datatype of email should be string
It gives only one first row email value
How many entries are present in the report file?
4 Email Id’s in Report file. But it Extracted one Email Id for all Columns.
What is the value for Index variable?
I see it takes only first row value as shown in picture by @shanmugapriyag
Actually got it I had not declared Index in lookup table Row Index
Thanks for your help
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.