|
| 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. |
|
|||||||
| Tags: distribution, excel, exporting, file, list |
|
|
Thread Tools | Display Modes |
|
#1
June 29th 07, 05:06 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Exporting Distribution List to Excel File
I'm working in Outlook 2000. I have a number of distribution lists that I
want to copy somehow as a backup. When I use the import/export wizard and try to map the fields, the fields are from the contact entry form. They don't work for a distribution list - many of the people on the list are not in a contacts list, but were just added to the distribution list manually. How do I map fields from a distribution list so the data will be exported to a file? I'm not tied to an Excel file - I really just want a way to copy all these people into some kind of file in case of disaster. I'd be happy to copy and paste the list into Word, but it doesn't give me that option. Thanks for any suggestions, Jen 
|
| Ads |
|
#2
June 29th 07, 07:54 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Distribution List to Excel File
Don't export. Just save the DL as a .txt file. Open it in Notepad, remove the top lines that don't include addresses, and save it. The result is a tab-delimited file that Excel can easily handle.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Jen" wrote in message ... I'm working in Outlook 2000. I have a number of distribution lists that I want to copy somehow as a backup. When I use the import/export wizard and try to map the fields, the fields are from the contact entry form. They don't work for a distribution list - many of the people on the list are not in a contacts list, but were just added to the distribution list manually. How do I map fields from a distribution list so the data will be exported to a file? I'm not tied to an Excel file - I really just want a way to copy all these people into some kind of file in case of disaster. I'd be happy to copy and paste the list into Word, but it doesn't give me that option. Thanks for any suggestions, Jen
|
|
#3
June 29th 07, 09:36 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Distribution List to Excel File
That did it Sue - thanks so much!
"Sue Mosher [MVP-Outlook]" wrote: Don't export. Just save the DL as a .txt file. Open it in Notepad, remove the top lines that don't include addresses, and save it. The result is a tab-delimited file that Excel can easily handle. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Jen" wrote in message ... I'm working in Outlook 2000. I have a number of distribution lists that I want to copy somehow as a backup. When I use the import/export wizard and try to map the fields, the fields are from the contact entry form. They don't work for a distribution list - many of the people on the list are not in a contacts list, but were just added to the distribution list manually. How do I map fields from a distribution list so the data will be exported to a file? I'm not tied to an Excel file - I really just want a way to copy all these people into some kind of file in case of disaster. I'd be happy to copy and paste the list into Word, but it doesn't give me that option. Thanks for any suggestions, Jen
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| exporting distribution lists to Excel spreadsheet | Noe1better | Outlook - Using Contacts | 3 | February 28th 07 07:45 PM |
| Exporting Distribution list | Rogers & Fleck Admin | Outlook - Using Contacts | 3 | January 18th 07 09:10 PM |
| Exporting Members on a distribution list | WooYing | Outlook - Using Contacts | 3 | September 29th 06 06:08 AM |
| Exporting distribution list into excel | Mezzazi | Outlook - Using Contacts | 1 | August 18th 06 12:52 PM |
| Exporting a distribution list | Bill Hunt | Outlook - Using Contacts | 4 | May 17th 06 03:03 PM |
Linear Mode
