Extracting Mailboxes using Macros as in Pivot table?

[Alam, Shamshad]

Hi Team,

I have exported values from Exchange 2007 Management Console as-
Display Name, Alias, Recipient Type Details, Primary SMTP Address, Server,
Database, Organizational Unit to the notepad file.

Is there any way to create Macro which can use the extracted notepad file
and the provide the details in Organized way in Excel file as Pivot Table?

If you need any addidtional information please let me know.

Thanks in Advance!

Shamshad
HCL

 

[Greg Glynn]

Shamshad,

Turn on the Macro reporter and record the importing of the file using
comma delimeters.

Once you have this code, you can modify it (ALT-F11) to perform the
process again as a macro.

The construction of a Pivot Table from the resulting columns can also
be recorded and tweaked to later repitition.