How do I export from an Outlook '07 Public Folder calendar into an Excel file? Using the menu Import/Export t allows only selections from my personal folders.
There is an Export wizard in Outlook. If is kind of buried .. File/Options .. on the Advanced tab. The choices for output format include csv and Excel. 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.
Discuss This Question: 1  Reply
There is an Export wizard in Outlook. If is kind of buried .. File/Options .. on the Advanced tab. The choices for output format include csv and Excel. 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.
Hope this helps.