exporting distribution lists to Excel spreadsheet

We have some large distribution groups and I need to export them into an
Excel spreadsheet. I need all the contacts and their info (mailing, phone
etc.) in the spreadsheet.

I've been looking all over and the best I can do is get the headers to
export, but none of the contact info.

Can anyone help?

This doesn't makes sense.
DL's don't contain phone numbers. All they contain is name and electronic
address--nothing else.
What is it you are really trying to do?
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
We have some large distribution groups and I need to export them into an
Excel spreadsheet. I need all the contacts and their info (mailing, phone
etc.) in the spreadsheet.

I've been looking all over and the best I can do is get the headers to
export, but none of the contact info.

Can anyone help?

In the distribution list you can view the members. When you view the members
you can see their phone numbers, addresses, emails, etc. I want all that
information, for everyone in 1 particular distribution list, in an Excel
spreadsheet.


"Russ Valentine [MVP-Outlook]" wrote:

This doesn't makes sense.
DL's don't contain phone numbers. All they contain is name and electronic
address--nothing else.
What is it you are really trying to do?
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
We have some large distribution groups and I need to export them into an
Excel spreadsheet. I need all the contacts and their info (mailing, phone
etc.) in the spreadsheet.

I've been looking all over and the best I can do is get the headers to
export, but none of the contact info.

Can anyone help?

Not in any DL I've ever seen. All you get is a name and an electronic
address.
What is your information store and Outlook version? All the rest of the
information is stored in the Contacts Folder, not the DL. It is from there
you would export. You can't export a DL.
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
In the distribution list you can view the members. When you view the
members
you can see their phone numbers, addresses, emails, etc. I want all that
information, for everyone in 1 particular distribution list, in an Excel
spreadsheet.


"Russ Valentine [MVP-Outlook]" wrote:

This doesn't makes sense.
DL's don't contain phone numbers. All they contain is name and electronic
address--nothing else.
What is it you are really trying to do?
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
We have some large distribution groups and I need to export them into
an
Excel spreadsheet. I need all the contacts and their info (mailing,
phone
etc.) in the spreadsheet.

I've been looking all over and the best I can do is get the headers to
export, but none of the contact info.

Can anyone help?

Yes, but if you double click on a name you get their detailed "card". So I'd
have to find each person in the DL and then export them individualy from the
contacts list? That will take forever - I figured they'd have simplified
it... Since all the names are right there, it could pull all the contact
cards.

I'm using MS Office Outlook 2003.





"Russ Valentine [MVP-Outlook]" wrote:

Not in any DL I've ever seen. All you get is a name and an electronic
address.
What is your information store and Outlook version? All the rest of the
information is stored in the Contacts Folder, not the DL. It is from there
you would export. You can't export a DL.
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
In the distribution list you can view the members. When you view the
members
you can see their phone numbers, addresses, emails, etc. I want all that
information, for everyone in 1 particular distribution list, in an Excel
spreadsheet.


"Russ Valentine [MVP-Outlook]" wrote:

This doesn't makes sense.
DL's don't contain phone numbers. All they contain is name and electronic
address--nothing else.
What is it you are really trying to do?
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
We have some large distribution groups and I need to export them into
an
Excel spreadsheet. I need all the contacts and their info (mailing,
phone
etc.) in the spreadsheet.

I've been looking all over and the best I can do is get the headers to
export, but none of the contact info.

Can anyone help?

Again, not in any DL I've ever seen. Double click yields a name and an
address and a format option. Period.
Perhaps you don't mean a distribution list. Are you talking about GAL or AD
entries? Those would not be Outlook DL's.
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
Yes, but if you double click on a name you get their detailed "card". So
I'd
have to find each person in the DL and then export them individualy from
the
contacts list? That will take forever - I figured they'd have simplified
it... Since all the names are right there, it could pull all the contact
cards.

I'm using MS Office Outlook 2003.





"Russ Valentine [MVP-Outlook]" wrote:

Not in any DL I've ever seen. All you get is a name and an electronic
address.
What is your information store and Outlook version? All the rest of the
information is stored in the Contacts Folder, not the DL. It is from
there
you would export. You can't export a DL.
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
In the distribution list you can view the members. When you view the
members
you can see their phone numbers, addresses, emails, etc. I want all
that
information, for everyone in 1 particular distribution list, in an
Excel
spreadsheet.


"Russ Valentine [MVP-Outlook]" wrote:

This doesn't makes sense.
DL's don't contain phone numbers. All they contain is name and
electronic
address--nothing else.
What is it you are really trying to do?
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
We have some large distribution groups and I need to export them
into
an
Excel spreadsheet. I need all the contacts and their info (mailing,
phone
etc.) in the spreadsheet.

I've been looking all over and the best I can do is get the headers
to
export, but none of the contact info.

Can anyone help?

Russ Valentine [MVP-Outlook] wrote:

Again, not in any DL I've ever seen. Double click yields a name and an
address and a format option. Period.

If the DL is formed of people from a GAL or a contact folder, then
double-clicking the Name field for a member in an open DL brings up either
the GAL entry or the Contact record associated with that member. I just
tried it.
--
Brian Tillman

Not on my planet. DL's created from the GAL or the AD are not the same as
DL's created in Outlook. As always, post insufficient information and an
accurate answer is impossible.
Point remains: You cannot export DL's. You can export Contact Records.
--
Russ Valentine
[MVP-Outlook]
"Brian Tillman" wrote in message
...
Russ Valentine [MVP-Outlook] wrote:

Again, not in any DL I've ever seen. Double click yields a name and an
address and a format option. Period.

If the DL is formed of people from a GAL or a contact folder, then
double-clicking the Name field for a member in an open DL brings up either
the GAL entry or the Contact record associated with that member. I just
tried it.
--
Brian Tillman

EXACTLY! It opens up a Contact record. I want those contact records exported
into a spreadsheet. Do I have to do each one individually?





"Brian Tillman" wrote:

Russ Valentine [MVP-Outlook] wrote:

Again, not in any DL I've ever seen. Double click yields a name and an
address and a format option. Period.

If the DL is formed of people from a GAL or a contact folder, then
double-clicking the Name field for a member in an open DL brings up either
the GAL entry or the Contact record associated with that member. I just
tried it.
--
Brian Tillman

What part of my post do you not understand?
Why are you unable to provide the information asked?
--
Russ Valentine
[MVP-Outlook]
"Sung" wrote in message
...
EXACTLY! It opens up a Contact record. I want those contact records
exported
into a spreadsheet. Do I have to do each one individually?





"Brian Tillman" wrote:

Russ Valentine [MVP-Outlook] wrote:

Again, not in any DL I've ever seen. Double click yields a name and an
address and a format option. Period.

If the DL is formed of people from a GAL or a contact folder, then
double-clicking the Name field for a member in an open DL brings up
either
the GAL entry or the Contact record associated with that member. I just
tried it.
--
Brian Tillman