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.
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
|
|
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 .. |
|||
|
|
|
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. |
|||
|
|
|
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. |
|||
|
|
|
There is a is a tool called Outlook Tools which can Export pf contacts to xls. |
||||
|
|
