Access 2007: Import Global Address List from Exchange Server

Contributed by Rob Rogers  
Tagged: Microsoft Office  

Inputing a list of employees, their email address, phone number, etc. can be a lengthy task to do by hand if you are dealing with a large number of people. If all of them are currently members of your domain and you are using Exchange as your mail server then you can compile this list off of the Global Address List in minutes versus hours. Here’s how:

1. Go to the Ribbon, click the External Data tab.

2. In the Import section, click More.

3. Select Outlook Folder from the dropdown menu.

4. Select the Import the data into a new table in the current database radio button.

5. Click OK.

6. Expand Address Books and select Global Address List.

7. Click Next.

8. If you wish to exclude any columns from your import, click on the column and then check the Do not import field (Skip) checkbox.

9. Click Next.

10. Click Next again.

11. Input a name for the table that the data will be imported to.

12. Click Finish.

You now have your list that you can export to Excel, or simply compile a report in Access.