Reader to Reader - 02 Nov 1999

[Editor's Note: Email your Exchange Server and Outlook solutions (400 words maximum) to R2R at [email protected]. Please include your phone number. We edit submissions for style, grammar, and length. If we print your contribution, you'll get $100.]

You can use two methods to export addresses from the Exchange directory. One method is to use the Save Window Contents option in the Exchange Administrator, which lets you display each type of email address in a separate column. However, sometimes this option doesn't give you the columns you want or the specific mailboxes or custom recipients (e.g., hidden recipients) you're looking for. Therefore, a second method you can use is the Directory Export command in Exchange Administrator.

A disadvantage of this method is that when you specify the column header email addresses in your output file, Exchange dumps all the addresses for each entry in no particular order. One row has the X.400 address followed by the SMTP address, and the next row has the addresses in reverse, for no apparent reason.

You can use Microsoft Excel to easily filter out each address type into an individual column. Follow these steps:

Note that this approach doesn't work on the secondary-proxy-addresses column because you might have multiple additional SMTP: or X.400: addresses in that column.

—Tony Lalli
[email protected]