Here's some code I got that dumps the members of ANY list (distribution
or security). It lets you specify a domain too: Save as a .VBS and
double-click. Works great. Two gripes of the script that I have are
that it only dumps the user logon name, and it randomly sorts the list.
It can be tweaked to dump a full username and alphabetize it however.
---
' ********************************************************************
'
' WriteGroupMembersToFile.vbs
' May 28, 2002
' by Jeff Durbin ([EMAIL PROTECTED] / [EMAIL PROTECTED])
'
' Create a text file list of members from a group.
'
' ********************************************************************
Option Explicit
On Error Resume Next
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim oFS, oFile, oGroup, strGroup, strDomain, oMember, _
oUser, strUser, UserDomain, strWelcomeTitle, strWelcomeMsg
strWelcomeTitle = "WriteGroupMembersToFile.vbs"
strWelcomeMsg = "This script creates/appends a text file with
usernames pulled from a security group." & vbCRLF
If MsgBox(strWelcomeMsg,vbOKCancel + vbInformation, strWelcomeTitle) =
vbCancel Then
WScript.Quit
End If
strGroup = InputBox("Group name to query?")
strDomain = InputBox("Domain name?")
Set oFS = CreateObject("Scripting.FileSystemObject")
Set oFile = oFS.OpenTextFile("userlist.txt", ForAppending, True)
Set oGroup = GetObject("WinNT://" & strDomain & "/" & strGroup &
",group")
if err.number <> 0 then
msgbox "The specified group name or domain name is not valid."
wscript.Quit
end if
For Each oMember in oGroup.Members
oFile.Write oMember.Name & vbCRLF
Next
oFile.Close
set oGroup = nothing
set oUser = nothing
set oFile = nothing
set oFS = nothing
msgbox "Done"
----
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Lynne July
Sent: Wednesday, January 11, 2006 7:16 PM
To: Exchange Discussions
Subject: RE: Distribution List
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.
_________________________________________________________________
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.
