Export contacts from a public folder and import as Active Directory contacts
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?
Madrillneo
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?
Madrillneo
Also have a look at these links ->
http://support.microsoft.com/?kbid=327620
http://support.microsoft.com/kb/q237677
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/directory/activedirectory/stepbystep/adbulk.mspx
Thanks,
Amit Aggarwal.
http://support.microsoft.com/?kbid=327620
http://support.microsoft.com/kb/q237677
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/directory/activedirectory/stepbystep/adbulk.mspx
Thanks,
Amit Aggarwal.
ASKER
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.
Madrilleno
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.
Madrilleno
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.
Thanks,
Amit Aggarwal.
If yes, then from your Outlook Contacts Folder, you can export them again using .csv and put it in AD.
Thanks,
Amit Aggarwal.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Think I will stick with the public folder, based on these comments.
1. http://support.microsoft.com/?kbid=238773
2. http://support.microsoft.com/?kbid=177123
Thanks,
Amit Aggarwal.