Export contacts from a public folder and import as Active Directory contacts

Posted on 2006-04-27
Last Modified: 2008-01-09
I have a public folder called "UK Customers" on my Exchange 5.5 server. This contains a couple of hundred sub-folders which are named by company. Each of these company sub-folders contains several contacts.

What I want to do is export all of these contacts as a .csv file and then import them into Active Directory as contacts, thus making them accessible through the Global Address List on my new Exchange 2003 server.

If I export to a .pst file (copied the folders on to my Outlook contacts folder), I get a checkbox for exporting all sub folders as well. If I choose .csv or Excel, then I cannot get the sub folders to go as well.

I have looked through the solutions on this site, but I can't find one which gets me where I need to go.

Any ideas?

Question by:Madrilleno
    LVL 12

    Expert Comment

    Did you check these KBs ?

    Amit Aggarwal.
    LVL 12

    Expert Comment


    Author Comment

    KB238733 - Looks at the GAL, not contacts in a Public Folder

    KB177123 - Refers to Outlook 97/98 - I am using Outlook 2003. Will not export sub-folders as noted in the question.

    KB327620 - Tells me how to get the .csv file into AD, or a .csv file out of AD. I'm aware of this bit of the solution, it's how to generate the CSV out of an Exchange 5.5 folder which I need. Remember, it's from a public folder with sub-folders.

    Q23677 - Similar to above, different data format.

    Technet link - same thing again.


    LVL 12

    Expert Comment

    when you export to a .pst file and copy the contacts to your outlook contacts folder. Do you get the hierarchy as well or contacts from all public folders (including subfolders) into a single Outlook Contacts Folder.
    If yes, then from your Outlook Contacts Folder, you can export them again using .csv and put it in AD.

    Amit Aggarwal.
    LVL 104

    Accepted Solution

    Are you sure that you want to do this?

    I can tell you now that pollution of the GAL in this way is not very popular with the users. Everytime a client has asked me to do it, I have been asked to remove it less than 48 hours later.
    If you have them split in to sub folders then that would make things a little more acceptable, but even so, if the company is quite small (ie there are less employees than the number of items you are importing in to the GAL) it will involve a lot of information being in the GAL that the vast majority of users will never use.

    I would leave them in the public folders and just set the public folder as an Outlook Address Book. That also makes management of the contacts much easier. Remember - when you have imported the items as a mail enabled contact so that they appear in the GAL, it takes someone with ADUC and the Exchange system management tools installed on their workstation - plus the additional permissions, to make any changes to those contacts.


    Author Comment

    Think I will stick with the public folder, based on these comments.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How does your email signature look on mobiles?

    Do your employees use mobile devices to reply to emails? With mobile becoming increasingly important to the business world, it is in your best interest to make sure that your email signature looks great across all types of devices.

    Suggested Solutions

    Title # Comments Views Activity
    Mailbox policy to disable mapi feature 5 20
    scripting, exchange 35 25
    exchange, scripts 3 34
    Windows Server with Exchange 7 23
    Email statistics and Mailbox database quotas You might have an interest in attaining information such as mailbox details, mailbox statistics and mailbox database details from Exchange server. At that point, knowing how to retrieve this information …
    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
    The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now