Multiple Filter in Get outlook mail messages

Hi, I am trying to apply two filters to “Get outlook mail messages” like following
Filter = “[Subject]=‘Report available’ and [Content] like yearly*”

This does not seems to be working. I have tried following and that works
Filter = “[Subject]=‘Report available’ and [Content]=‘yearly’”

and I have also tried following which works as well
Filter = “[Subject]=‘Report available’” then inside for each on the fetched emails add an if condition where email.Body.Contains(“Yearly”)

So question is how to use wild card in Get outlook mail messages filter.

I wanna know “how to use wild card in Get outlook mail messages filter.” too

“@SQL=urn:schemas:httpmail:subject=‘Report available’ AND urn:schemas:httpmail:textdescription like ‘%yearly%’”

Still haven’t found the best way to do this. I am trying to use the "received]= " criteria and still not getting any results.

I have to get Outlook mail based on From address (eg: xxx@xxx.com) using Filter property.

I am trying to combine searching for a Wildcard in the subject, AND looking for a specific From Adress, like this:

“@SQL=urn:schemas:httpmail:subject like ‘%SV%’ AND urn:schemas:httpmail:from=‘xxxxx@xxxxx.com’”

But it does not work. Any ideas? Tried so many combinations but it keeps throwing an exception.

/d

EDIT: It’s easy with “[From]=‘xxxx@xxxx.com’” , but it’s the combination with the wildcard in the Subject that I can’t manage to get.

did u get any solution of filtering outlook mails??

Try this :

“@SQL=urn:schemas:httpmail:subject like’%Report available%’ AND urn:schemas:httpmail:textdescription like ‘%yearly%’”

P/s : Please Retype ‘’ and ’ symbol or else you will get an error

I have this Date Range filter in get outlook mail message.

My variable.
assign 1= DateTime
assign 2= DateTime
mailMessage = List

image

But mailmessage result to = “0” , could someone check where it went wrong.

Thank you!

Hi, how would I alter this expression to look for multiple subjects? I tried OR but it does not work.

TIA