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?
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%'"
Welcome to Community!!
Try this way
currentItem.SenderEmailAddress.Contains("@abc.com") OR currentItem.SenderEmailAddress.Contains("@efg.com")
I hope it helps!!
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.
It is not my folder, but a company folder, so I cannot change their outlook categorization settings
Let me check filter for you
When I do:
it gave me error message “Cannot parse condition” when I run the project
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.
Once try this
“[senderemailaddress] = ‘firstname.lastname@example.org’ or [senderemailaddress] =‘email@example.com’”
I want to filter by domain, which is the parts behind the at, not sender