Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How can I export an Exchange 2007 public folder (IPM.Contact) as an Excel or Access file? We use Outlook 2010 on the client side.

share|improve this question

5 Answers 5

up vote 0 down vote accepted

There is an Export wizard in Outlook 2010. If is kind of buried .. File/Options .. on the Advanced tab. The choices for output format include csv and Excel 97-2003.

HOWEVER, I don't think it is possible to run the "Export" wizard over the public folders, only over your mailbox or mail files.

So, for a one off, copy the public folder into a sub-folder in your mailbox (or into a PST) and then run the wizard. Automating it will take some effort ..

share|improve this answer

This is actually pretty easy

Highlight an ordinary folder within Public Folders (not a contacts folder) then go through the motions of export to file. You will be prompted with the folder selector, accept this time you will be able to browse all of Public Folders and select the PF Contacts folder that you want to export.

Bada-Bing, Bada-Boom!

share|improve this answer

There is a is a tool called Outlook Tools which can Export pf contacts to xls.

share|improve this answer

We have used Public Folder contact lists as distribution lists (bad practice, I know), but this worked for me.

Open the contact list. Save as a text file. Open the text file with excel. The contact name and the email address will be in two different columns.

share|improve this answer

Tomjedrz is correct. You cannot export Public Folder contents to a CSV / Excel document (there is no support for exporting to an access file). However, you can export Public Folder contents to a .PST file as indicated.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.