Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Exporting Exchange Addressbook?

0 views
Skip to first unread message

Gene

unread,
Dec 30, 2003, 12:15:09 PM12/30/03
to
How do I export the main address book in Exchange 2000. I
used to be able do this in Exchange 5.5. Export the
address book names and e-mail adresses into excel and
print them out for the whole company to use. Thanks Gene

Robin

unread,
Dec 30, 2003, 12:38:36 PM12/30/03
to
Gene wrote:

Export to a comma delimited (or tab delimited file) through the ESM.

Nino Bilic [MSFT]

unread,
Dec 30, 2003, 1:08:05 PM12/30/03
to
Well - let me ask you this - I am not understanding what you are trying to
do?

Because - Exchange Address List (I guess the GAL?) is available to all
Outlook clients anyway... why would you want to print it out?

Or - is it something else that you are trying to print?

--
Sincerely,

Nino Bilic
MCSE+I, W2K MCSE, MCSA, A+
Microsoft Exchange Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

This posting is provided "AS IS" with no warranties, and confers no rights.

Find out about Strategic Technology Protection Program and get our Security
Toolkit! Go to http://www.microsoft.com/security .

"Gene" <ge...@turnnet.com> wrote in message
news:0acf01c3cef8$7a784720$a601...@phx.gbl...

anon...@discussions.microsoft.com

unread,
Dec 30, 2003, 1:15:47 PM12/30/03
to
How I can see the names but there is no export feature
like in Exchange 5.5

>.
>

Robin

unread,
Dec 30, 2003, 1:17:59 PM12/30/03
to
Nino Bilic [MSFT] wrote:

> Well - let me ask you this - I am not understanding what you are
> trying to do?
>
> Because - Exchange Address List (I guess the GAL?) is available to all
> Outlook clients anyway... why would you want to print it out?
>
> Or - is it something else that you are trying to print?


My guess is that he wants to provide people with a printed list,
because there are still those that prefer to have the paper document
instead of the digital...

Robin

unread,
Dec 30, 2003, 1:28:16 PM12/30/03
to
<anon...@discussions.microsoft.com> wrote:

I misspoke in my first reply, my apologies. If you want to get a list
of users along with email addresses, go into your Active Directory
Users and Computers MMC, and click on the OU that houses the users you
are looking for. Change the view to include the columns you would like
in your exported list, and the right click on that OU and choose
"Export List." With Exchange 2000 user management was taken out of the
ESM and integrated into the AD console.

Short of knowing your exact OU layout, those are the best instructions
I can provide.

Ben Winzenz

unread,
Dec 30, 2003, 2:09:48 PM12/30/03
to
If you have multiple OU's, that can be quite taxing. An easier way might be
to run CSVDE and export the user information that you desire.

--
Ben Winzenz
Network Engineer
Gardner & White

Exchange FAQ's: http://www.swinc.com/resource/exch_faq.htm
Exchange 2000 FAQ's: http://www.swinc.com/resource/e2kfaq.htm


"Robin" <rhabe...@avazpour.com> wrote in message
news:e9wByKwz...@TK2MSFTNGP12.phx.gbl...

anon...@discussions.microsoft.com

unread,
Dec 30, 2003, 2:21:34 PM12/30/03
to
Ok NOT everyone has the outlook client some only use
outlook web access (OWA). The list is distributed to
clients and customers as well so everyone has the e-
mails. It was easy to do in Exchange 5.5... Thanks Gene

>.
>

anon...@discussions.microsoft.com

unread,
Dec 30, 2003, 2:57:11 PM12/30/03
to
Oh that is so it... Thank you I cannot beleive I forgot
that they integrated everything into ADUC.... Ooops
thanks again. Gene

>.
>

Gene

unread,
Dec 30, 2003, 3:06:02 PM12/30/03
to
CSDVE? is that a utility?
>.
>

Nino Bilic [MSFT]

unread,
Dec 30, 2003, 3:09:04 PM12/30/03
to
Well, probably your best bet is to use CSVDE to export the OU where the
users are. Do not specify any attributes when exporting, but rather
manipulate the CSV file by deleting the columns that you do not need - it is
going to be easier that way and less room for trouble as the CSVDE command
line gets more and more complex. It is not always the most intuitive tool :(

Then you can leave only the columns for display name and email addresses and
print that out.

--
Sincerely,

Nino Bilic
MCSE+I, W2K MCSE, MCSA, A+
Microsoft Exchange Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

This posting is provided "AS IS" with no warranties, and confers no rights.

Find out about Strategic Technology Protection Program and get our Security
Toolkit! Go to http://www.microsoft.com/security .

<anon...@discussions.microsoft.com> wrote in message
news:00b701c3cf0a$23591890$a501...@phx.gbl...

Ben Winzenz

unread,
Dec 30, 2003, 3:24:45 PM12/30/03
to
Yup. Native tool included with Windows 2000 - I can't remember if you have
to install the Support Tools or Admin pak though. It queries AD for the
information you specify and exports it to a CSV file. Go to a command
prompt on your AD server and run csvde /?. You ought to get a display like
below. It's a pretty powerful tool once you figure out how to use it.

C:\winnt\system32>csvde

CSV Directory Exchange

General Parameters
==================
-i Turn on Import Mode (The default is Export)
-f filename Input or Output filename
-s servername The server to bind to (Default to DC of logged in Domain)
-v Turn on Verbose Mode
-c FromDN ToDN Replace occurences of FromDN to ToDN
-j Log File Location
-t Port Number (default = 389)
-u Use Unicode format
-? Help


Export Specific
===============
-d RootDN The root of the LDAP search (Default to Naming Context)
-r Filter LDAP search filter (Default to "(objectClass=*)")
-p SearchScope Search Scope (Base/OneLevel/Subtree)
-l list List of attributes (comma separated) to look for in an
LDAP search
-o list List of attributes (comma separated) to omit from input.
-g Disable Paged Search.
-m Enable the SAM logic on export.
-n Do not export binary values


Import
======
-k The import will go on ignoring 'Constraint Violation' and
'Object Already Exists' errors


Credentials Establishment
=========================
Note that if no credentials is specified, CSVDE will bind as the currently
logged on user, using SSPI.

-a UserDN [Password | *] Simple authentication
-b UserName Domain [Password | *] SSPI bind method

Example: Simple import of current domain
csvde -i -f INPUT.CSV

Example: Simple export of current domain
csvde -f OUTPUT.CSV

Example: Export of specific domain with credentials
csvde -m -f OUTPUT.CSV
-b USERNAME DOMAINNAME *
-s SERVERNAME
-d "cn=users,DC=DOMAINNAME,DC=Microsoft,DC=Com"
-r "(objectClass=user)"


--
Ben Winzenz
Network Engineer
Gardner & White

Exchange FAQ's: http://www.swinc.com/resource/exch_faq.htm
Exchange 2000 FAQ's: http://www.swinc.com/resource/e2kfaq.htm


"Gene" <anon...@discussions.microsoft.com> wrote in message
news:024701c3cf10$598dd6c0$a301...@phx.gbl...

AJ Hugo

unread,
Jan 5, 2004, 12:38:43 PM1/5/04
to
I too am interested in exporting the GAL. For auditing
pourposes I need to be able to export all my users and
thier information, address, phone, e-mail etc. Other than
a 3rd party tool is there an easy MS tool to use?

>.
>

jmhj

unread,
Feb 6, 2004, 1:55:54 PM2/6/04
to
I'd like to be able to export to a file so that it can be imported to a
pst for folks that are mobile and never connnect to our domain. I have
been trying to write a script for this purpose. Does anyone know where
there is a sample I can look at. I tried to use the query builder in
ESM to get started but I am struggling with it right now. I like to see
how to query and then dump to a csv. I can create a csv right now but
my script is being a pain when it gets to the query.

Andy Webb

unread,
Feb 6, 2004, 2:04:35 PM2/6/04
to
you can use csvde from the windows 2000 support tools to export the data to
a csv file.

Andy

"jmhj" <jm...@hotmail.com> wrote in message
news:uTWGaLO7...@TK2MSFTNGP12.phx.gbl...

0 new messages