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 ac…

Read excel content certain words and email

sangeethaneelavannan1 (Sangeetha Neelavannan) January 9, 2023, 2:28am 2

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

1 Like

Topic		Replies	Views
Read Excel sheets and compare to data table to send emails Help	4	1944	January 31, 2020
Read Outlook Subject and Save into Excel Help	5	1942	August 17, 2018
Type into format Academy Feedback excel , uiautomation , activities , question	8	843	May 28, 2020
Reading excel sending email issue Activities mail , studio , question	5	469	April 17, 2023
Write excel data in word template Activities datatable , excel , uiautomation , activities , question	4	2495	March 14, 2022

Read excel content certain words and email

Related topics