KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q168716: XADM: How to Import Manager Data into Exchange

Article: Q168716
Product(s): Microsoft Exchange
Version(s): winnt:4.0,5.0,5.5
Operating System(s): 
Keyword(s): kbusage exc4 exc5 exc55
Last Modified: 16-OCT-1999

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Exchange Server, versions 4.0, 5.0, 5.5 
-------------------------------------------------------------------------------

SUMMARY
=======

The Organization property page may be used to enter optional information in the
Address Book about the mailbox owner's manager and direct reports (if any).

Manager information may be imported into the Exchange mailboxes by creating a
.Csv file that contains a Manager column header.

MORE INFORMATION
================

Create a .Csv file by exporting the addresses from the Administrator program and
modifying the file to add the new column "Manager" and Alias Name of the user
who will be listed as the manager for that mailbox.

Close, then import this modified .Csv file into Exchange, using Tools / Directory
Import command.

Any mailbox owner who is listed as a manager of another user will have Direct
Report information displayed within his or her mailbox properties.

Each recipient who reports to the mailbox owner (Manager) will be listed in the
Direct Reports dialog box of that mailbox owner.

REFERENCES
==========

The Exchange Server 4.0 CD contains a sample Mailbox.csv file that can be found
at:

  \SUPPORT\SAMPLES\Csvs\MAILBOX\Mailbox.csv

Contained in this file are all 93 fields that can be associated with any Exchange
Server mailbox. This .Csv file may be used to create the "master headers" for a
.Csv file for use in importing user and mailbox information into Exchange
Server.

The Microsoft BackOffice Resource Kit contains a utility called Header.exe, which
can be used to create a .Csv file with only the required headers.

Additional query words:

======================================================================
Keywords          : kbusage exc4 exc5 exc55 
Technology        : kbExchangeSearch kbExchange500 kbExchange550 kbExchange400 kbZNotKeyword2
Version           : winnt:4.0,5.0,5.5
Issue type        : kbhowto

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.