How can I export a distribution list to excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

patrick.horsman@gmail.com - 23 May 2006 22:31 GMT

Since moving to an exchange server our DL is too large and I just get
an error when I go to send an email... How can I export a distribution
list to excel?

Reply to this Message

Russ Valentine [MVP-Outlook] - 23 May 2006 23:02 GMT

DL's never survive exporting. What makes you think you want to do that?

Signature

Russ Valentine
[MVP-Outlook]

> Since moving to an exchange server our DL is too large and I just get
> an error when I go to send an email... How can I export a distribution
> list to excel?

Reply to this Message

Sue Mosher [MVP-Outlook] - 23 May 2006 23:31 GMT

FIle | Save As. If you save the DL as a .txt file, you can open it in Notepad, remove the non-address information at the top, then open it in Excel as a tab-delimited file.

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Since moving to an exchange server our DL is too large and I just get
> an error when I go to send an email... How can I export a distribution
> list to excel?

Reply to this Message

Brian Tillman - 24 May 2006 01:35 GMT

> Since moving to an exchange server our DL is too large and I just get
> an error when I go to send an email... How can I export a
> distribution list to excel?

Open the DL and click File>Save As and choose a txt file type. The DL will
be saved as a Tab Separated Values file and Excel should be able to open it.

That said, I don't know what you can do with it aferward because there's no
way I know to import to a DL.

Signature

Brian Tillman

Reply to this Message