Exporting Exchange Global Address List to Excel with VBScript

This vbscript exports an Exchange GAL to an Excel spreadsheet. The important line to change is objCommand.CommandText which must be modified to reflect your Active Directory domain and the address book field you want to search for. Any information about the user object can be retrieved by additional modification of the script.

An example of querying Active Directory using PowerShell custom objects is also available.

To use, modify the following line:

For example, if your Active Directory domain is internal.microsoft.com and you want a spreadsheet of everyone that had Operations for the company field, the line would be modified to this:

If you wanted an Excel spreadsheet of everyone with Vice President in the title field, it should be changed to this: