Friday, April 2, 2010

Get the Global Address List exported to Excel

First off I found this site. http://support.microsoft.com/?id=238773 and followed the instructions to get the global address list copied to my outlook.


Basically it says In Outlook go to the Folder view. Find the Contacts folder and add a new sub-folder. Then go to Tools > Address Book... On this window go to Tools > Options... and change the Keep personal addresses in: box to this new folder you have created. Then click OK. Change the  Show Names from the: box to Global Address List and highlight all of the entries. Then go to File > Add to Contacts. Go back to Tools > Options... and change the Keep personal addresses in: box back to Contacts. Then click OK and close the other box.  This gives you the Global Address List in your Outlook.


Now you need to export it.  Go to File > Import and Export... and choose Export to a file.  Click Next. Choose Microsoft Excel and click Next. Then choose you newly created folder of the Global Address List and click Next. Pick a file name and click Next. Then Finish.

No comments:

Post a Comment