Get Outlool Mail Message 's Help

Hello Forum,
I would really appreciated if you could help me to write a cote on “Get Outlook Mail Message” activity for filtering on 4 levels:

  1. Filter must be for unread emails AND
    2.- filter must be emails having an excel attachments types: . csv ; . xlsx ; . xls AND
  2. filter those emails market as “Red Category”

To get that i should write a single code in the Expressions Editor option section to comply with theses three filters

What is more , i would really appreciated if you could give advice where to find information for learning
@sql : request syntaxis (because i found difficulties to understand the logic for writing and reading queries)

and the ones with format " " = ’ ’ "


Hi @Ricchch

  • For Filtering for unread emails you can check the “OnlyUnreadMessages” in the properties option of the Get Outlook Mail Messages.
  • For Filtering for Red Category and email has an attachment use below expression in Filter
    “@SQL=(”“urn:schemas:httpmail:hasattachment”" = 1 AND ““urn:schemas-microsoft-com:office:office#Keywords”” = ‘Red category’)"
  • You can also use regex in filter option of Save Attachment activity to filter the files with required extensions

Also please refer to for more filter options

Hope this helps