How do I export a distribution list?

[Linnea]

I'd like to export the email adresseses from several distribution lists into
an excel spreadsheet. It seems to be impossible. Is there any easy way to do
this?

 

[Sue Mosher [MVP-Outlook]]

Save each DL as a .txt file. Open that file in Notepad. Remove the first few lines so that all you have are the names and addresses. Save the ..txt file. You can now import it into Excel, because it is a tab-delimited file.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers