I’d like to get only the messages where the body contains word “January”. Tried with something like this:
“@SQL=urn:schemas:httpmail:textdescription like ‘%January%’”
but it does not work.
Could You help me how to make such filter in GetOutlookMailMessages activity?
@wenar58700 Please visit the official documentation of the activity. It provides two examples of how you can search for a string in an email body. This is the link: Get Outlook Mail Messages
One thing regarding this. I had similar task, 2000 users and around 1000 emails. The solution was developed using ReFramework.
You could get all the emails without filter once, and then using LINQ you can filter out those emails.
This saves a lot of time and it will help if outlook or mail server is slow