Windows 8 and 8.1 Forums


How to export all details of Global address book?

  1. #1


    Posts : 149
    Windows 8 Pro

    How to export all details of Global address book?


    Hello, we run Exchange and have Office 2010. Is there a way to export the entire address book to a csv file that will include all information, such as mobile number? I messed with it, but the numbers were not exporting I only see names. Active Directory is where we add the information, then it syncs with exchange. Do I do it via the active director? If so, how? If via outlook, how?

    Again, I am wanting to be able to export all numbers attached to the name.




    Thanks!

      My System SpecsSystem Spec

  2. #2


    Posts : 46
    Microsoft Windows 8.1 64-bit Professional


    Hello Mike6623,

    Have a look at this tutorial at our sister forum.
    Pay special attention to step E of part four of option one.


    Good luck and keep us posted,
    Nommy
      My System SpecsSystem Spec

  3. #3


    Posts : 959
    Windows 8.1, 10


    Which variety of Office 2010 do you have - is it one of the versions with MS Access?

    It's a few years ago that I did this, so maybe different in Office 2010, but I seem to remember that in Access 2003 you could just Link to Exchange as a data source; hopefully Access 2010 can too.

    You could then pull the data into an Access table and do whatever you wanted with it, including exporting it.

    These days Excel 2010 may be able to to the same, I guess, so you might try that too.
      My System SpecsSystem Spec

  4. #4


    Posts : 149
    Windows 8 Pro


    Quote Originally Posted by DavidY View Post
    Which variety of Office 2010 do you have - is it one of the versions with MS Access?

    It's a few years ago that I did this, so maybe different in Office 2010, but I seem to remember that in Access 2003 you could just Link to Exchange as a data source; hopefully Access 2010 can too.

    You could then pull the data into an Access table and do whatever you wanted with it, including exporting it.

    These days Excel 2010 may be able to to the same, I guess, so you might try that too.
    It is 2010 Professional plus
      My System SpecsSystem Spec

  5. #5


    Posts : 959
    Windows 8.1, 10


    Ah thanks for that - so that means you have Microsoft Access then.

    It certainly was easy to link to Exchange in Access 2003, so hopefully it's still easy in 2010.

    First, open Access and create a new Database.

    I don't have access to a version of Access which links to Exchange, but I think the next step is to look on the External Data tab on the ribbon, then click on the "More" dropdown about a third of the way across. On that dropdown, with any luck you'll have an option for Outlook Folder or maybe for Exchange. Then you select Import (or Link if you'll need to keep doing this on future occasions).

    The next bit is where I'm guessing, but hopefully if you look in the next dialog box for Address Books, you should find the Global Address list, and select that.

    Once you've got the table imported or linked, Right Click on it and you should be able to Export it to various formats, including CSV (called Text File).

    Personally I don't like CSV as a format because if you have commas in the data (quite likely in an Address list), can mess things up, so one of the other formats may be better, depending on what you're trying to do next.
      My System SpecsSystem Spec

  6. #6


    Posts : 149
    Windows 8 Pro


    Thanks, I will let you know once I try these steps!
      My System SpecsSystem Spec

  7. #7


    Posts : 149
    Windows 8 Pro


    It's weird. When I create the new database and go to import, and I am at the outlook folder, it shows nothing even though there are outlook database files there! It can never be easy
      My System SpecsSystem Spec

  8. #8


    Posts : 149
    Windows 8 Pro


    Click image for larger versionClick image for larger version
    Is there a reason that would happen? Here is what I have in my outlook folder and what I see when trying to import it.
      My System SpecsSystem Spec

  9. #9


    Posts : 959
    Windows 8.1, 10


    Which option did you use to get to that?

    I think you need to click on the "More" dropdown (see my picture) and then Outlook Folder, but the message you have is what you might get if you clicked on the nearby "ODBC Database" option.

    Click image for larger version
      My System SpecsSystem Spec

How to export all details of Global address book?
Related Threads
Hello, When I fget into my GAB in outlook 2013, a name doesn't appear under "global address book" but it does appear if I switch it to "all users". This person is set up on the exchange server and in active directory, as they rest of the people are. Why would the name not appear in the default GAB,...
OK I'm confused. I finally managed to import all my contacts from roadrunner and Live to Outlook, but the contacts appear under PEOPLE. How do I get them to the address book so that when I click TO: to send an email the contacts appear?????
Why can I not sync my Global Address Book? When I add info via active directory, it updates in the GAB, not in the contact list, and the contact list is what shows on the phone....and is what we need to update as we add info!!!!! Why isn't this possible? That isn't "syncing" that is just refreshing...
How can I add all my accounts in Outlook into the Contacts in Outlook or create an address book from them? Thanks.
Solved new outlook 7 address book? in Browsers & Mail
My Windows 7 laptop crashed but before it did I copied my Microsoft Office 7 outlook mail Address Book into my Documents. Bought a new Windows 8 laptop & installed a new Office 7 outlook in it. I got a computer store to copy what they could off the old computer hard drive. I opened what they...
I hope so Will hate to have to type in all of that info. Can anybody help ?
Eight Forums Android App Eight Forums IOS App Follow us on Facebook