I have one question on manipulating two different excel files.
For reference I have attached images.
From Image1, I need to match name with names from Image2 and based on that email address to extracted.
Then send the data from image 1 to extracted email ID one by one.
for EX: I have extracted email@example.com and its name is XYZ in image 1. So only data related to name "xyz " to be send out to corresponding email address.
convert the second datatable to dictionary so that you can get the email address of that row
dict_emailids=dt2.AsEnumerable.ToDictionary(Function(x) x(0).ToString.Trim,Function(x) x(1).ToString.Trim)
Sequence2.xaml (11.4 KB)
refer the sequence
You can use join data table activity to match Unique names with emails. Then, mails can be sent by iterating the resultant datatable.
You can use a If Condition here
It is matched