exporting Outlook distribution lists to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

karl - 30 Jun 2004 13:47 GMT

Hi,
I would need some help on how to 'export' an Outlook
distribution list to MS Excel. Any suggestions?
Advice on this would be greatly appreciated.
Responses pleae to karl.ortenburgxxx@tiscali.co.uk remove
xxx

Reply to this Message

Sue Mosher [MVP-Outlook] - 30 Jun 2004 15:48 GMT

Choose File | Save As and save the DL as a text file. Open it in Notepad to
remove the couple of lines at the top that give the name of the DL. What you
have left will be a nice tab-delimited file that Excel should be able to
handle just fine.

Signature

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

> Hi,
> I would need some help on how to 'export' an Outlook
> distribution list to MS Excel. Any suggestions?
> Advice on this would be greatly appreciated.
> Responses pleae to karl.ortenburgxxx@tiscali.co.uk remove
> xxx

Reply to this Message