Get Outlook Mail Messages: Condition is not valid COMException

[jarous]

I have created Get outlook Mail Message activity with the following filter
“[Subject]=‘Aviatrix “+Quarter+” “+YearDMR+” Financial Information’ or [Subject]=‘Arrcus “+Quarter+” “+YearDMR+” Financial Information’”. It was working fine with above two subject filter, however when I added another 31 different subjects I am getting below message.
Source: Get outlook mail messages
Message: Condition not valid
Exception type: COMException
could you please advise what I am doing wrong.
Thank you

[pikorpa (Piotr Kołakowski)]

Hey,
please take a look this topic:

Get Outlook Mail Messages Filter Filter By Subject

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. Thank you SOLUTION: "@SQL=urn:schemas:httpmail:subject LIKE '%Your Item%'" OR "@SQL=""http://schemas.microsoft.com/mapi/proptag/0x1000001E""…

SOLUTION:
"@SQL=urn:schemas:httpmail:subject LIKE '%Your Item%'"
OR
"@SQL=""http://schemas.microsoft.com/mapi/proptag/0x1000001E"" like '%Your Item%'"