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

Help Studio
, , , ,
1

Hi Folks,

I have one question on manipulating two different excel files.

For reference I have attached images.
image

image

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 xyz@gmail.com and its name is XYZ in image 1. So only data related to name "xyz " to be send out to corresponding email address.

2

@sayali_gujarathi1

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

3

You can use join data table activity to match Unique names with emails. Then, mails can be sent by iterating the resultant datatable.

4

Hi @Sayali_Kharde

var1=xyz
var2=xyz@gmail.com

You can use a If Condition here

If
var2.Contains(var1)

Then
It is matched

Else
Not Matched