I want to use the filter option on the Get Outlook Mail Messages activity. I am trying to get all emails that contain the subject “Billing”. What I currently have is “[Subject]=‘Billing’” but this does not return anything. What am I doing wrong? I do not want to use a for loop to iterate over emails unless I can mark the ones without Billing as unread.
"@SQL=urn:schemas:httpmail:subject LIKE '%Your Item%'"
"@SQL=""http://schemas.microsoft.com/mapi/proptag/0x1000001E"" like '%Your Item%'"
If you want to search for multiple items
"@SQL=urn:schemas:httpmail:subject like '%Your Item1%' or urn:schemas:httpmail:subject like '%Your Item2%'"