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

Exporting Public Folder to Excel or Access

Folks,

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

Thanks.
Avi
0
Avi-Solomon
Asked:
Avi-Solomon
1 Solution
 
Exchange_AdminCommented:
I think you may be able to export it to a .CSV file. You can then open this up in Excel.
0
 
hsclaterCommented:
You could always just copy all the emails into a folder in your mailbox, and then export straight to Excel??
0
 
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.

Avi
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Avi-SolomonAuthor Commented:
Nobody has an answer for this
0
 
Avi-SolomonAuthor Commented:
Well,

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.
0
 
CetusMODCommented:
PAQed with points refunded (500)

CetusMOD
Community Support Moderator
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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