Consulting

Results 1 to 2 of 2

Thread: I need to find a way to highlight certain text in the incoming emails

  1. #1
    VBAX Newbie
    Joined
    Mar 2018
    Posts
    1
    Location

    I need to find a way to highlight certain text in the incoming emails

    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

  2. #2
    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
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •