XADM: How to Use Excel to Generate Reports for Mailbox Resources

The Exchange Administrator program of Exchange 2000 can export mailbox or public folder resource reports to a .csv file. This article describes how to generate reports for your mailbox resources by using Microsoft Excel to work with an imported file.

You can use the Exchange Administrator program to list or sort the Mailbox Resources (located under the Server-Private Information Store) for a particular server.

You can also save this information to a comma-delimited file and import the file into Excel so that you can manipulate the data. To do so:

1. In Exchange Administrator, click any mailbox in the right pane.
2. On the File menu, click Save Window Contents.
3. Type a file name for the .csv file, and then click OK.
   The .csv file is now ready for you to import into Excel.

For additional information about how to generate a report on the mailbox resources in use by a particular server from Crystal Reports, click the article number below to view the article in the Microsoft Knowledge Base: