Archive for the ‘Outlook’ Category

Export Distribution List email addresses from Outlook

Wednesday, September 1st, 2004

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!