Exporting an exchange public folder contact list to Excel/Access

Question

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.

Solution 1

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

Solution 2

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.