It has been a year since you posted your question here for the so-called
un-professionals to help you. I find myself today with the same dilema.
Just for the record, I understood your question from the first time I read it
(before the expert person replied initially) but maybe that is because I have
the same situtation to deal with. I found his postings very rude to say the
least. Whatever happened to customer service with courtesy?

The guy is right if you just look at the DL as a list of names with email
addresses but each one of those names is listed in your contacts with further
information such as addresses, titles, company info, etc. If you click on
their names, it will take you to their detailed contact info.

Just wondering if you ever did find a solution as I have 95 names in one DL
that I need to do a label merge to send out a mass mailing. I need this ASAP
before I start typing them from scratch! I have been searching for weeks now
hoping there is a way to export these addresses from outlook so I don't have
to print each one and start typing my labels just to get them out the door!

Please let me know ASAP... Thanks, Robin Noe, University of Cincinnati
email:

"Sung" wrote:

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?

Your scenario would require writing code to look up the contact record data based on the names and addresses in the distribution list. The only thing that can be "exported" from the DL is the names and addresses, because that is all the information that the DL itself contains.

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

"Noe1better" wrote in message ...

Just wondering if you ever did find a solution as I have 95 names in one DL
that I need to do a label merge to send out a mass mailing. I need this ASAP
before I start typing them from scratch! I have been searching for weeks now
hoping there is a way to export these addresses from outlook so I don't have
to print each one and start typing my labels just to get them out the door!

Noe1better wrote:

I found his postings very rude to say the least. Whatever happened to
customer service with courtesy?

This isn't a customer service venue. It is a peer-to-peer newsgroup.

The guy is right if you just look at the DL as a list of names with
email addresses but each one of those names is listed in your
contacts with further information such as addresses, titles, company
info, etc.

Not necessarily. DLs can contain names and addresses that are NOT in the
Contacts folder.

Just wondering if you ever did find a solution as I have 95 names in
one DL that I need to do a label merge to send out a mass mailing. I
need this ASAP before I start typing them from scratch! I have been
searching for weeks now hoping there is a way to export these
addresses from outlook so I don't have to print each one and start
typing my labels just to get them out the door!

Save the DL as a text file (FileSave As). This will be a tab-separated
values file, which Excel can read. You can then use Mail Merge and use the
Excel spreadsheet as the data source.

FINALLY! The answer I was looking for...file, save as...now why didn't I
think of that? Thanks!!!

"Brian Tillman" wrote:

Noe1better wrote:

I found his postings very rude to say the least. Whatever happened to
customer service with courtesy?

This isn't a customer service venue. It is a peer-to-peer newsgroup.

The guy is right if you just look at the DL as a list of names with
email addresses but each one of those names is listed in your
contacts with further information such as addresses, titles, company
info, etc.

Not necessarily. DLs can contain names and addresses that are NOT in the
Contacts folder.

Just wondering if you ever did find a solution as I have 95 names in
one DL that I need to do a label merge to send out a mass mailing. I
need this ASAP before I start typing them from scratch! I have been
searching for weeks now hoping there is a way to export these
addresses from outlook so I don't have to print each one and start
typing my labels just to get them out the door!

Save the DL as a text file (FileSave As). This will be a tab-separated
values file, which Excel can read. You can then use Mail Merge and use the
Excel spreadsheet as the data source.