How to filter by email_address domain with exchangelib?

Question

I'm having the following problem to get the emails. Also, I want to filter emails by email_address domain.

Code:

from exchangelib import Q
from exchangelib import Account, Configuration, Credentials, DELEGATE, errors
...

account = connect(SERVER_URL, EMAIL, PASSWORD)

# Get the folder object
folder = account.root / 'Top of Information Store' / 'Inbox'

# Get emails
q = (Q(subject__contains='key_word') and Q(sender__contains='mydomain1.com'))
emails = folder.all().filter(q)

for item in emails:
  print(item.subject)

Output:

(Nothing Prints)

Erik Cederstrand · Answer 1 · 2021-01-27T09:41:06.140

0

__contains in combination with a list translates to "contains A and B". That's never going to match in your case. You need to use Q objects and boolean operators to get "contains A or B":

from exchangelib import Q

folder.filter(Q(sender__contains='mydomain1.com') | Q(sender__contains='mydomain2.com'))

See more at https://ecederstrand.github.io/exchangelib/#searching

edited Jan 27 '21 at 09:41

answered Jan 13 '21 at 08:34

Erik Cederstrand

9,643
8
39
63

Thanks for your answer. However, I want to filter by email address domain instead of subject. – EEEEH Jan 14 '21 at 01:01
Just change `subject` to `sender` in my example. – Erik Cederstrand Jan 14 '21 at 05:23
Work on "sender=who@mydomain.com". But didn't work on "sender__contains=mydomain.com" – EEEEH Jan 15 '21 at 06:54
1

Ok, maybe EWS doesn't support "contains" filtering on the "sender" field. – Erik Cederstrand Jan 15 '21 at 08:47

How to filter by email_address domain with exchangelib?

1 Answers1