How to export distribution list to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

will~ - 04 May 2006 15:06 GMT

Would like to know how to export distribution list to excel, so that it could
be shared with someone who are not using outlook. I have tried using the
export feature in outlook without success, (File - import and export - export
to a file - microsoft excel - select 'Contacts'), as this only export the
contacts, but not the distribution list or their contents. Please assist,

Windows XP Pro, Outlook 2003, Excel 2003. Many thanks in advance,

Reply to this Message

Sue Mosher [MVP-Outlook] - 04 May 2006 15:41 GMT

Save the list as a .txt file. Open it in Notepad. Remove the few lines at the top so that only the names and addresses remain. Save it, and you will have a nice tab-delimited file that Excel can open.

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

> Would like to know how to export distribution list to excel, so that it could
> be shared with someone who are not using outlook. I have tried using the
[quoted text clipped - 3 lines]
>
> Windows XP Pro, Outlook 2003, Excel 2003. Many thanks in advance,

Reply to this Message

Russ Valentine [MVP-Outlook] - 04 May 2006 15:48 GMT

Save it as a text file. Open it in Excel.

Signature

Russ Valentine
[MVP-Outlook]

> Would like to know how to export distribution list to excel, so that it
> could
[quoted text clipped - 5 lines]
>
> Windows XP Pro, Outlook 2003, Excel 2003. Many thanks in advance,

Reply to this Message