I am assuming your files will be in a folder and you have read the Name +Email excel to a Datatable named (v_InputDataTable), please follow below steps
Read the files from the folder using Directory.GetFiles(“FolderName”,“*.xlsx”) which will give an output as Array variable
Use Foreach Loop and give the array variable as input for the loop, and inside loop have a Assign activity as below:
String FileName = new System.IO.FileInfo("your file path ").Name
FileName variable will give the name of the file which you can use it in the select query
In another assign use as below to filter:
string Email_ID = v_InputDataTable.AsEnumerable.Where(Function (x) x(“Name”).Tostring = FileName).ToList(0).Item(“Email”).Tostring
Read range activity : read the excelsheet to get the datatable(dt)
assign activity : listEmail = dt.AsEnumerable.Select(Function (row) row.Field(Of String)(“Email”)).tolist
Assign activity : emails = String.Join(“;”,listEmails.ToArray))
Send outlook mail : To = emails