Hi, How do read an excel and recognize with certain words and send email?
eg. Excel from cell E2 to E100 if recognize with words “New York” or “LA” then will send an A template.
If recognize in cell E2 to E100 with words “Florida” or “Las Vegas” will send B template.
Do I use if and read range activities? Please help.
Hi @koolrc812
Read range activity to store the data from excel
Inside if yourDT.AsEnumerable().Any(Function(x) x(“Column1”).ToString = DesiredValue then send template A to mail
dt_countries - DataTable?
dt_countries.AsEnumerable.Select(function(x) x(“countries”).ToString).ToArray showing compiler error(s) encountered processing expression … value of type ‘1-dimensional array of String’ cannot be converted to ‘String’.?
this part works. Thanks heaps.
for the below part if condition not sure why it shows - compiler error(s) encountered processing expression … [Option Strict On disallows late binding]?