HomeWindowsMicrosoft OfficeAccess 2007: Import Global Address List from Exchange Server

Access 2007: Import Global Address List from Exchange Server

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.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.


Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

error: Content is protected !!