I am trying to use outlook to filter through emails that have the same body layout, but with different info filled out.
Here is what the body of the email looks like.
Office ID #:
Best day and time to contact:
Reason for client call:
Is there a way to use the advaced sql outlook filter to check to see if there are any characters after : to make sure the info was filled out?
I have "urn:schemas:httpmail:textdescription" LIKE '%Office ID #:%' which is the basic filter to see if the message contains "Office ID #:, but I want it to check to see if there is any text after the :
Any assistance would be appreciated