Get all Outlook Mail Messages without any categories

Help
, , ,
1

Hello,

I am trying to extract all mail messages without any category assigned to them from my Outlook, but I can only get it to work if I filter for a specific category, like “[categories] = ‘red category’”

image

But what I want is the opposite: to get all the mail messages that have no category.

Could anyone help me?

2

Hi @apietens
remove the filter option and try to get all mail messages
and loop it through for each item in Mails

and get all the mails

Thanks
Ashwin S

3

Can you try this @apietens

“[categories] =‘Blue category’”

1 Like
4

Hi @AshwinS2,

Thank you. I have done that and that works, but i’d rather have it filtered straightaway. So if you have any solution for that, i’d like to know.

5

Hi there…I have the same problem and its proving impossible to resolve with an elegant solution.
Please could you share the logic of your loop solution . I need to get rid of any mails that have any Catagory assigned ie I only want the blank or unassigned ones…

6

this simple filter works perfectly…
“Not [categories] > 0” in the filter expression…

7

…but not in all environments. Migrated my xaml to the work environment and the filter broke…

8

…found a robust solution in Microsoft DASL documentation: this is the exact filter string required:
“@SQL=” & Chr(34) & _
“urn:schemas-microsoft-com:office:office#Keywords” & _
Chr(34) & " is null"

9

Can you assist me with how to extract outlook mail categories with UiPath ?