scriptygoddess RSS Feed
 
 
 
 

Export Distribution List email addresses from 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. 1
    Anders:

    (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. 2
    Mark O'brien:

    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.

Bookmarks

WordPress Resources

Meta