How to get email addresses from a distribution list?

Question

I am trying to retrieve email addresses of a DL in Exchange 2010. I tried code from this url and am getting an error.

https://github.com/ecederstrand/exchangelib

# primary_smtp_address: what should be provided here?
# cred: do we need to provide admin users to retrieve data?

from exchangelib import DELEGATE, Account, Credentials, Configuration
cred = Credentials(username='domain\username',password='xxxx')
config = Configuration(server='exchangeserver.com', credentials=cred)
account = Account(primary_smtp_address='def@xyz.com', config=config, autodiscover=False, access_type=DELEGATE)
for mailbox in account.protocol.epxand_dl('abc@xyz.com'):
    print(mailbox.email_address)

Instead of result am getting below error.

Traceback (most recent call last): File "E:\Sheik-Backup\Sheik-Backup\Workspace\FlaskProject\maillist.py", line 11, in a=Account(...) File "E:\Python Virtual-Env\Development\lib\site-packages\exchangelib\account.py", line 57, in init if '@' not in primary_smtp_address: TypeError: argument of type 'ellipsis' is not iterable

Kindly help me to understand – Sheik Kalidh May 09 '19 at 04:14 — Sheik Kalidh, May 09 '19 at 04:14

Erik Cederstrand · Accepted Answer · 2019-05-09T08:23:06.743

0

A Python Ellipsis (...) is sometimes used as a placeholder for verbose code that would make an example less readable. But it happens to also be valid Python syntax.

Probably, you read an example somewhere using a = Account(...) for brevity, but that's not how you set up an account. You need to replace the ... with arguments that to your account, as described in https://github.com/ecederstrand/exchangelib#setup-and-connecting

Finally, to answer your questions: You need to connect as any user that has permission to call the ExpandDL service on the given DL. That could be a normal user or a special system account, depending on your access restrictions on the Exchange server. primary_smtp_address is the email address of the account you are connecting to.

edited May 09 '19 at 08:23

answered May 09 '19 at 05:35

Erik Cederstrand

9,643
8
39
63

Thanks for your guidance. Pleas help me with code to retrieve mail address from DL. – Sheik Kalidh May 09 '19 at 06:22
I updated your example code so it should work, assuming the connecting account has permission to do what you want. – Erik Cederstrand May 09 '19 at 08:22
Hi Eric, am getting this error while executing above code: – Sheik Kalidh May 09 '19 at 10:04
for mailbox in a.protocol.epxand_dl('abc@xyz.com'): AttributeError: 'Protocol' object has no attribute 'epxand_dl' – Sheik Kalidh May 09 '19 at 10:05
Sorry.. account which am trying to expand is not DL. Let me try with another account and confirm you. – Sheik Kalidh May 09 '19 at 10:18
Hi Eric, i tried with proper account (DL) , but still am getting same error. please help. – Sheik Kalidh May 09 '19 at 11:00
1

HiEric,I got it. there was an issue with DL am trying to expand.now working fine. Thank you so much for your inputs. – Sheik Kalidh May 09 '19 at 11:26

How to get email addresses from a distribution list?

1 Answers1