To export the GAL to Microsoft Excel, you first need to move it to a Contacts folder in Outlook.

See Part One for instructions on how to export Outlook contacts to Excel for data management. Long field names are a pain—they use too much space and take forever to type—so shorten them.

Start file export Open Outlook, then open your Address Book/Contacts folder (click the people icon at the bottom of the left panel). From the Contacts screen, click File > Open & Export > Import ...

If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.