Getting email Id and immediate supervisor Name

Help Studio
1

Hi,

i have a excel file with users first and last name i need to find the email id and immediate supervisor name with the help for first and last name from outlook , Kindly help

2

@Amrutha.mg

Read the data into datatable and then use filter datatable using first name and last name

the resultant row is the required row with values you need

cheers

4

Hi @Amrutha.mg

You can try this expression:

emailId = dtInput.AsEnumerable.where(Function (row) row.item(“FirstName”).ToString=“RequiredName” and row.item(“LastName”).ToString=“RequiredSurname” ).CopyToDataTable.AsEnumerable.Select(Function (row) row.item(“EmailId”).ToString).FirstOrDefault

Regards.

5

i don’t have the emailId in Excel in need to take that from Outlook, Kindly help