How do I export a distribution list from Outlook to Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BrianC - 14 Mar 2005 20:09 GMT

I'm trying to export a distribution list that I created in my contacts to an
Excel file. I also want to import a list of email addresses from Excel to a
distribution list in Outlook.

Reply to this Message

Sue Mosher [MVP-Outlook] - 14 Mar 2005 20:29 GMT

Save the DL as a .txt file. Open it in Notepad to remove all but the names
and addresses. Close and save. You now have a nice tab-delimited file you
can open in Excel.

Outlook provides no way to import addresses to a DL.

Signature

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

> I'm trying to export a distribution list that I created in my contacts to
> an
> Excel file. I also want to import a list of email addresses from Excel to
> a
> distribution list in Outlook.

Reply to this Message