A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Exporting Distribution List to Excel File



 
 
Thread Tools Display Modes
  #1  
Old June 29th, 2007, 05:06 PM posted to microsoft.public.outlook.contacts
Jen
external usenet poster
 
Posts: 544
Default 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
  #2  
Old June 29th, 2007, 07:54 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 7,177
Default 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  
Old June 29th, 2007, 09:36 PM posted to microsoft.public.outlook.contacts
Jen
external usenet poster
 
Posts: 544
Default 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


  #4  
Old March 24th, 2010, 08:23 PM posted to microsoft.public.outlook.contacts
MSKI
external usenet poster
 
Posts: 1
Default Exporting Distribution List to Excel File



"Jen" wrote:

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

  #5  
Old March 24th, 2010, 09:17 PM posted to microsoft.public.outlook.contacts
Russ Valentine
external usenet poster
 
Posts: 1,155
Default Exporting Distribution List to Excel File

Did you have a question, or did you just want to repost this?
Question has been answered many times.
--
Russ Valentine
"MSKI" wrote in message
news


"Jen" wrote:

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.