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.