Export O365 Offline Global Address Book

%3CLINGO-SUB%20id%3D%22lingo-sub-226065%22%20slang%3D%22en-US%22%3EExport%20O365%20Offline%20Global%20Address%20Book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-226065%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22single-excerpt%22%3E%3CP%3EWhile%20I%20can%20export%20my%20own%20Contacts%20folder%2C%20I%20don%E2%80%99t%20seem%20to%20be%20able%20to%20export%20our%20company%E2%80%99s%20Offline%20Address%20Book%20or%20the%20Global%20Address%20List%20(GAL).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20import%20this%20list%20in%20another%20application%20and%20sometimes%20also%20use%20it%20for%20mailings%20both%20electronically%20and%20to%20their%20physical%20address%20which%20is%20stored%20in%20the%20GAL%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20export%20these%20Exchange%20address%20lists%20via%20Outlook%3F%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-226065%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EEnterprise%20K1%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProPlus%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-226709%22%20slang%3D%22en-US%22%3ERE%3A%20Export%20O365%20Offline%20Global%20Address%20Book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-226709%22%20slang%3D%22en-US%22%3ECan%20confirm%20with%20Vasil%2C%20a%20beer%20would%20probably%20do%20the%20trick!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-226302%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20O365%20Offline%20Global%20Address%20Book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-226302%22%20slang%3D%22en-US%22%3E%3CP%3EOr%20you%20can%20buy%20your%20Exchange%20Admin%20a%20beer%20and%20ask%20him%20to%20export%20it%20to%20CSV%20file%20via%20PowerShell%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-226171%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20O365%20Offline%20Global%20Address%20Book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-226171%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20what%20Nuno%20said%2C%20i%20think%20one%20step%20was%20missing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20if%20you%20have%20not%2C%20you%20can%20add%20all%20the%20users%20to%20your%20contacts%20section%20from%20the%20GAL%2FOAB%2C%20you%20can%20even%20create%20a%20new%20group%20for%20them.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20once%20they%20are%20in%20the%20contacts%20section%20the%20export%20is%20very%20easy!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3COL%3E%3CLI%3EOpen%20your%20Address%20Book%20(keyboard%20shortcut%3C%2FLI%3E%3CLI%3ESelect%20the%26nbsp%3Blist%20which%20contains%20the%20contacts.%3C%2FLI%3E%3CLI%3ESelect%20all%20the%20contacts%20that%20you%20wish%20to%20export.%3C%2FLI%3E%3CLI%3ERight%20click%20on%20your%20selection.%3C%2FLI%3E%3CLI%3EChoose%20Add%20to%20Contacts.%20(I%20would%20add%20them%20to%20a%20specific%20folder)%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EIt%20is%20worth%20nothing%20if%20you%20have%20a%20large%20GAL%2C%20this%20could%20take%20a%20bit%20and%20be%20slow%2C%20just%20let%20it%20do%20its%20thing%2C%20and%20if%20you%20are%20worried%20about%20it%2C%20perhaps%20set%20this%20up%20on%20an%20extra%20machine%20and%20not%20your%20primary%20computer.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EOnce%20you%20have%20done%20that%2C%20then%20you%20just%20need%20to%20export%20the%20selected%20contacts.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20would%20move%20them%20into%20a%20specific%20folder%20in%20the%20create%20contact%20phase%2C%20but%20if%20not%20you%20should%20be%20able%20to%20find%20out%20which%20ones%20are%20new%20by%20the%20date%20created.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps!%3CBR%20%2F%3EAdam%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-226097%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20O365%20Offline%20Global%20Address%20Book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-226097%22%20slang%3D%22en-US%22%3EHi%20Bharati%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20select%20the%20contacts%20from%20the%20Gal%2C%20then%20add%20to%20your%20account%20and%20after%20you%20can%20Export%20it.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi All,

 

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).

 

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 can I export these Exchange address lists via Outlook?

4 Replies
Highlighted
Hi Bharati,

You can select the contacts from the Gal, then add to your account and after you can Export it.
Highlighted

Hello,

 

In addition to what Nuno said, i think one step was missing.

 

First if you have not, you can add all the users to your contacts section from the GAL/OAB, you can even create a new group for them.

Then once they are in the contacts section the export is very easy!

  1. Open your Address Book (keyboard shortcut
  2. Select the list which contains the contacts.
  3. Select all the contacts that you wish to export.
  4. Right click on your selection.
  5. Choose Add to Contacts. (I would add them to a specific folder)

It is worth nothing if you have a large GAL, this could take a bit and be slow, just let it do its thing, and if you are worried about it, perhaps set this up on an extra machine and not your primary computer.

Once you have done that, then you just need to export the selected contacts.

I would move them into a specific folder in the create contact phase, but if not you should be able to find out which ones are new by the date created.

Hope this helps!
Adam




Highlighted

Or you can buy your Exchange Admin a beer and ask him to export it to CSV file via PowerShell :)

Highlighted
Can confirm with Vasil, a beer would probably do the trick!