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!

Related posts:

  1. Search from WordPress Admin (Post Listing) Redirecting to Home Page This is possibly the most bizarre thing I've ever seen....

Related posts brought to you by Yet Another Related Posts Plugin.

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

About


Advertisements