View Single Post
  #3  
Old October 26th 06, 03:29 PM posted to microsoft.public.outlook.contacts
Brian Tillman
external usenet poster
 
Posts: 17,443
Default exporting distribution lists to Excel spreadsheet

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.

Ads
 

Home Loan - Myspace Layouts - Remortgages - Payday Loan - Loans