• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

Exporting Public Folder to Excel or Access


I have an email enabled public folder. People send emails to this folder. I would like to export the contents of the public folder to either Excel or Access so I can run reports and queries against the data in excel or access.

The import/export wizard does NOT seem to permit me to export a Public Folder to XLS. It will allow me to export a folder in MY mailbox, but not a public folder. I'm running Outlook XP (2002). Does Outlook 2003 address the issue?

I'd prefer to automate the process, but am willing to do it manually.

Any ideas???

1 Solution
I think you may be able to export it to a .CSV file. You can then open this up in Excel.
You could always just copy all the emails into a folder in your mailbox, and then export straight to Excel??
Avi-SolomonAuthor Commented:
You CAN'T do it to a CSV from a public folder.

As far as copying it to my mailbox, that would not be reasonable as the amount of data in the public folder will be in the hundreds of MB.

I did find another solution to this issue which was interesting. It said to Export the public folder to a PST (which is the ONLY export that support public folders), then open the PST file in Outlook, then perform an export to CSV or XLS or MDB from the PST file. That seemed to work but sure required a lot of hoops to jump through.

Essentially, I have a public folder that receives email. I want to be able to dump out the contents of the folder to an Access DB (or XLS file) so I can run queries against the data which I don't belive I can really do in Outlook (non-programmatically).

Thanks for your input.

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Avi-SolomonAuthor Commented:
Nobody has an answer for this
Avi-SolomonAuthor Commented:

I'm going to submit my own answer. Can I give myself the points? Here's the one thing I DID do.

I enabled full text indexing of the public folder in exchange. At least I can now perform decent searches against the folder. It's not a perfect solution but may be all I can do for now.
PAQed with points refunded (500)

Community Support Moderator
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now