Importing Outlook Address Book into Excel

[kpark91]

Hi,

How do I import Outlook Address book (Global Address List) into Excel?

[HansV]

If you have Access, you can import the GAL into an Access table, then export that to an Excel spreadsheet.
Another option is to use code - see Exporting Exchange Global Address List to Excel with VBScript.
Yet another option is to copy the GAL entries into a Contacts folder in Outlook, and to export this folder to an Excel spreadsheet.

[kpark91]

Thank you~! Works great.