

- #HOW TO EXPORT CONTACTS FROM OUTLOOK PUBLIC FOLDER TO EXCEL HOW TO#
- #HOW TO EXPORT CONTACTS FROM OUTLOOK PUBLIC FOLDER TO EXCEL OFFLINE#


Note: In Outlook 2007, you can also temporarily change the default Contacts creation folder. You can then easily move your filtered list of contacts to another folder and use the Export option in Outlook to export this folder or customize your view with the fields you need and copy them directly to Excel. When customizing your Contacts view, make sure you first select a list view such as Phone List.Ī short Search Query to find your added Contacts.
#HOW TO EXPORT CONTACTS FROM OUTLOOK PUBLIC FOLDER TO EXCEL HOW TO#
As you just added these contacts, their created and/or modified date and time will all be the same and thus they'll end up being grouped together.ĭetails about how to do this is similar as discussed in Clean up duplicates after emails got redownloaded. Your options are to change the sorting order or to apply a filter to your view or simply use Instant Search. If you did not move your own Contacts to a different folder, you can still quickly distinguish between your own contacts and the ones you added from the GAL via the Modified or Created date. Step 2: Filtering and exporting the added contacts They usually can produce a list much quicker directly from Exchange or Active Directory and are also less resource intensive to the servers. When you want to export a large Global Address List (GAL) in full, it is recommended to contact your Exchange or User administrator instead. This process is relatively slow so selecting lots of contacts could result in Outlook being inaccessible for a longer period of time. Via a right click, you can quickly add contacts from the Exchange Global Address List to your own Contacts folder.

I need to import this list in another application and sometimes also use it for mailings both electronically and to their physical address which is stored in the GAL as well.
#HOW TO EXPORT CONTACTS FROM OUTLOOK PUBLIC FOLDER TO EXCEL OFFLINE#
While I can export my own Contacts folder, I don’t seem to be able to export our company’s Offline Address Book or the Global Address List (GAL).
