scriptygoddess

01 Sep, 2004

Export Distribution List email addresses from Outlook

Posted by: Jennifer In: Outlook

This isn't really script related, but I searched everywhere online and while I saw the question asked many times, I never saw an answer posted.

The problem is that I wanted to extract a list of email addresses from a distribution list that I had created in Outlook. In the 2003 version, you can apparently just click a little button to expand the list (and then you could just copy out the list of email addresses, I would assume)

This doesn't help me, because I don't have the 2003 version.

However, I WAS able to get the addresses into an excel file by doing the following:

1) Click on contacts
2) double click on the distribution list to "edit/view" it.
3) Go to File -> Save As
4) Save it as a .txt file

Then open that .txt file in Excel, (default import text file settings should work fine) and you're all set!

So easy – and yet so bizarre that I couldn't find that ANYWHERE!

2 Responses to "Export Distribution List email addresses from Outlook"

1 | Anders

January 24th, 2005 at 8:09 am

Avatar

(I have to answer to this even though it's an old article)
Oohh. I did the same thing, googled all over the place. And then, found your post. That easy. I'm in chock! (And big thanks)

2 | Mark O'brien

June 1st, 2005 at 8:12 pm

Avatar

Dear Jennifer, Same story as Anders. Have been tearing my hair trying to find a solution to this problem. Your post has saved my life and a lot of work. Cheers.

Featured Sponsors

Genesis Framework for WordPress

Advertise Here


  • Scott: Just moved changed the site URL as WP's installed in a subfolder. Cookie clearance worked for me. Thanks!
  • Stephen Lareau: Hi great blog thanks. Just thought I would add that it helps to put target = like this:1-800-555-1212 and
  • Cord Blomquist: Jennifer, you may want to check out tp2wp.com, a new service my company just launched that converts TypePad and Movable Type export files into WordPre

About


Advertisements