Save it as a .txt file. Open it in Notepad to remove all but the names and addresses.

Signature
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
> How do I export a distribution list to an excel file? When I try to do that
> all I get in the worksheet is the name of the distribution list.