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!
January 24th, 2005 at 8:09 am
(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)
June 1st, 2005 at 8:12 pm
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.