------ Register to get rid of these "In Post" ads! ------


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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-archives/111624-extracting-mailboxes-using-macros-pivot-table.html#post400031

------ Register to get rid of these "In Post" ads! ------


Shamshad,

Turn on the Macro reporter and record the importing of the file using
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-archives/111624-extracting-mailboxes-using-macros-pivot-table.html#post412088
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.