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