hi All

I was wondering whether someone can help me with the following as I am new to vba.

I need to write a code that extracts the distribution list names and its members from Outlook and exports it into an excel spreadsheet.

Is this something that is relatively easy to do?

I found the following code in google but need to modify it so it just search through all in one go rather than specifying the name of the list and then export it into an excel sheet which is on g:\names.xlsx

Please Login or Register  to view this content.
The code above works from outlook however [I] would like to run this from excel and ti return list names and its members and count of how many people in each list.

Thnaks in advance