Here's another option. The University of Wisconsin has a link to a utility to export distribution lists from Outlook. This utility was written back in '97 or so. I've been using it for years, and it still works great - even with the newest version of Outlook.
Here's the link... http://www.uwsp.edu/it/exchange/client_ext/expdl/expdl.html After you export a DL, a message will be created in your inbox with the contents of the DL. Lynne -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kat Collins Sent: Wednesday, January 11, 2006 1:22 PM To: Exchange Discussions Subject: Re: Distribution List The quickest way that I know is to: 1. Open a new message in Outlook. 2. Enter the Distribution Group address in the address field and resolve it. 3. "Expand" the list to display in the address field by clicking the + to the left of the DistGroup name. -- This will pop up a window that tells you that once you do this you cannot reverse it. 4. Click OK to show all of the email addresses like this: Mary Smith; John Jones; Sam Spade; Santa Claus 5. Copy the list into Word (it doesn't work well in Excel) 6. Search and replace the address separators (; ) with a manual line break (^|), so that the list displays like this: Mary Smith John Jones Sam Spade Santa Claus Now you can copy this list into Excel or other applications you need. Kat Collins On 1/11/06, McCready, Robert <[EMAIL PROTECTED]> wrote: > Surely there's an easy way to export the users of a distribution list > to an excel spreadsheet, notepad, word, something....anything? > > I just want an electronic copy of one of our list with about 600 users > on it, but I'm not seeing an option anywhere to export. > > _________________________________________________________________ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange > To subscribe: http://e-newsletters.internet.com/discussionlists.html/ > To unsubscribe send a blank email to [EMAIL PROTECTED] > Exchange List admin: [EMAIL PROTECTED] > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > > -- Kat Collins - "The Email of the species is more powerful than the Mail!" "The human voice is the organ of the soul." Henry Wadsworth Longfellow _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
