Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   How to export distribution list to excel (http://www.outlookbanter.com/outlook-using-contacts/13700-how-export-distribution-list-excel.html)

will~ May 4th 06 03:06 PM

How to export distribution list to excel
 
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,



Sue Mosher [MVP-Outlook] May 4th 06 03:41 PM

How to export distribution list to excel
 
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.

--
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

"will~" wrote in message ...
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,



Russ Valentine [MVP-Outlook] May 4th 06 03:48 PM

How to export distribution list to excel
 
Save it as a text file. Open it in Excel.
--
Russ Valentine
[MVP-Outlook]
"will~" wrote in message
...
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,






All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com