Reporting Outlook Distribution List Members to a Spreadsheet

[tomwilson64]

First, if there's a board like Mr. Excel for Outlook (Outlook 2010 in my case), I'd be glad to ask this there.

I have 98 distribution lists all existing as the only contents of a Contacts folder. These distribution lists have not been audited in some time. I'd like to find an automated way to report out the members of each list by name and e-mail address so I could distribute the report for review to appropriate users.

When I try to export, it only exports the name of the distribution list, not the members within each distribution list.

Any assistance would be appreciated.

Thanks!

Tom

 

[Andrew Poulsom]

I found this by Googling:

http://www.vbaexpress.com/forum/archive/index.php/t-31383.html

 

[tomwilson64]

I appreciate the effort and result you've found. Can you give me an idea of how to proceed? I last did macros in Lotus 1-2-3 in 1997. I'm smarter than that makes me sound and have had a VBA class about 6 years ago, but didn't use it further.

Would I open a blank spreadsheet, create a macro in that spreadsheet, paste the text of this script and then run the macro? Then it will connect to Outlook and allow me to point to a distribution list? Or is there more I'm not understanding about it that I need to know to set up?

Tom