scalar email

Export Exchange Global Address List to Access

Outlook does not provide you an option to export the Exchange Global Address list to any kind of style. You don’t also have the choice to type while searching, which drives me insane. If I wish to see that works in the Houston office, I don’t wish to have to go via the entire list.

Sure, you can obtain your exchange manager to export a list for you, but thankfully there’s an easy way making use of Microsoft Access.

Prerequisite: You will need to make certain you do this on a computer system that has Outlook mounted and also set up.

Start by opening up Access, and developing a space database. Currently choose File Get External Data Import

You will certainly see a basic file open dialog. In here, you will certainly open the drop-down food selection for Files of type, and you must see Exchange() in the listing:

As quickly as you select that, it will instantly open the Import Exchange/Outlook Wizard. Select the Global Address List in the tree, and afterwards hit Next. Note that you might export other listings utilizing this exact same method if you wanted to.

At this point, you will certainly be asked where you intend to save the data. If this is the first time, you will just select brand-new table. You could alternatively press the information right into any type of table you desire, but we’re simply going to import the entire point.

Now you must see the brand-new table in your database, as well as it will have the entire components of the global address list.

Leave a Reply