Hi,
How do I import Outlook Address book (Global Address List) into Excel?
Importing Outlook Address Book into Excel
-
- StarLounger
- Posts: 61
- Joined: 29 Jul 2010, 14:52
Importing Outlook Address Book into Excel
I don't have one
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Importing Outlook Address Book into Excel
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.
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.
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 61
- Joined: 29 Jul 2010, 14:52