Send excel data row by row to each user using uipath by email

Hi Folks,

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 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.

Hi @Sayali_Kharde


You can use a If Condition here


It is matched

Not Matched