Getoutlookmail activity filter by domains

[Joanne_Chang_LAX]

Hi, I’m trying to apply multiple filters for different domains.

For example, I have multiple domains:

and so on

I would like to get mails only from the specific domains.

Currently I’m using this filter:

But this only works with one domain.
How can I filter multiple domains?

[Vikas_M]

@Joanne_Chang_LAX
Have you tried using OR operator

Just try whether the Or operator works or not

"@SQL=" + Chr(34) + "http://schemas.microsoft.com/mapi/proptag/0x007D001E" + Chr(34) + " like '%@abc.com%' OR " + Chr(34) + "http://schemas.microsoft.com/mapi/proptag/0x007D001E" + Chr(34) + " like '%@efg.com%'"

[lrtetala (Lakshman Reddy)]

Hi @Joanne_Chang_LAX

Welcome to Community!!

Try this way

currentItem.SenderEmailAddress.Contains("@abc.com") OR currentItem.SenderEmailAddress.Contains("@efg.com")

I hope it helps!!

[raja.arslankhan]

@Joanne_Chang_LAX
I would suggest one solution which is actually Generic solution and less loaded also.
Make a separate folder in Outlook Account.
Set rule for this folder as who can send mails for this folder.
When you will give 3 email addresses to it. You will get all emails to it.

Then Read that folder without any filter.

[Joanne_Chang_LAX]

It is not my folder, but a company folder, so I cannot change their outlook categorization settings

[raja.arslankhan]

@Joanne_Chang_LAX
Oh ok.
Let me check filter for you

[Joanne_Chang_LAX]

When I do:

it gave me error message “Cannot parse condition” when I run the project

[Joanne_Chang_LAX]

Hi, thanks for your help, but I don’t want to get all the mails first before filtering, because there are more than 1000 mails to process, and I’m afraid that will take too much time.

[lrtetala (Lakshman Reddy)]

@Joanne_Chang_LAX

Once try this

“[senderemailaddress] = ‘abc@gmail.com’ or [senderemailaddress] =‘xyz@gmail.com’”

[Joanne_Chang_LAX]

I want to filter by domain, which is the parts behind the at, not sender