|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
May 4th 06, 03:06 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
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, 
|
| Ads |
|
#2
May 4th 06, 03:41 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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,
|
|
#3
May 4th 06, 03:48 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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,
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Export and Import Distribution list | Tom | Outlook - General Queries | 3 | April 6th 06 01:31 PM |
| How do I export a distribution list? | Linnea | Outlook - Using Contacts | 1 | March 24th 06 08:41 PM |
| Can I export a Global Address List to Excel? | Josh Craig | Outlook - Using Contacts | 2 | March 14th 06 01:30 PM |
| Export Excel to Outlook Contacts | Kerri | Outlook - Using Contacts | 1 | March 8th 06 08:43 PM |
| export a public contact folder to excel? | mjb | Outlook - Using Contacts | 1 | January 20th 06 05:44 AM |
Linear Mode
