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!

No related posts.

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


  • Curt: If anyone comes across this with similar issues I was able to sort out the pagination issues painlessly with easyCommentsPaginate from http://www.mush
  • Christopher: Yeah, it is indeed hard to do. And something remains elusive about why the pagination never worked. I tried everything I could find. Regardless, I
  • Jennifer: Hi Christopher, always hard to bug test stuff like that remotely. Sorry those didn't help. Glad you found a solution though :)

About


Advertisements