A friend had a semi-regular request for the members of a long list of distribution groups (70-80). I hacked together something that dumped everthing to a big text file which he then had to convert to an Excel spreadsheet. Not an optimal solution for automation. I thought this was an excellent time to learn how to put data in Excel.
The script as written takes input from a text file of the group (Distribution lists, but any group would work) but you could change that to a query easily enough.