And yes I know it is manual, but it does accomplish the result without
too much aggravation for me.  I can almost do it blindfolded!!  Since
I only have to do this about 4 times a year, it works...

On 1/11/06, Kat Collins <[EMAIL PROTECTED]> wrote:
> 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
>


--
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.

Reply via email to