PDA

View Full Version : I need to find a way to highlight certain text in the incoming emails



Tatyana
03-06-2018, 01:49 PM
I need to find a way to highlight certain text in the incoming emails if these conditions are met. Search each incoming emails from certain email address and look at text after "Street Address:” wording. If the address after this line is the same as in some other email for that day, this address needs to be highlighted.
For example:
Street Address: 123 Main St
Address Line 2: Suite 100
City: New York
State / Province: NY
Postal / Zip Code: 14221
In this example, I need to highlight 123 Main St but only if I already received an email with that street address that day.

Thank you!
Tatyana

gmayor
03-08-2018, 12:21 AM
Frankly this would be a major programming exercise. You would have to create an Excel workbook to log the addresses and the dates and then you would have to check each message for the address against what is stored in the workbook for the day in question. If the address exists then you would have to mark the message - perhaps using categories - or move it to another folder, and if it doesn't exist add it to the worksheet with the date.

What is the purpose of the exercise?

You might find http://www.gmayor.com/extract_data_from_email.htm and http://www.gmayor.com/extract_email_data_addin.htm useful