distribution list to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anoop K - 20 Jul 2006 16:16 GMT

I have 19 distribution lists with just e-mails on them, no names or contacts
attached. I want to transfer all these e-mails to excel or better yet to an
html document so i can search through them and delete old e-mails. Is there
any way to do this? Everytime I use the export function I get a blank excel
document with just headers. I am using Outlook 2003. Thanks.

Reply to this Message

Sue Mosher [MVP-Outlook] - 20 Jul 2006 16:23 GMT

Save each one as a text file, open in Notepad to delete the first few lines, leaving the names, then open in Excel.

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

>I have 19 distribution lists with just e-mails on them, no names or contacts
> attached. I want to transfer all these e-mails to excel or better yet to an
> html document so i can search through them and delete old e-mails. Is there
> any way to do this? Everytime I use the export function I get a blank excel
> document with just headers. I am using Outlook 2003. Thanks.

Reply to this Message