Export Email Header Script for Excel or Access

I'm looking for a method to export the following information out of an Exchange Mailbox to Excel or Acesss

Subject, Sender, Recipeint, date_Sent, date_received.

Does anyone have a solution that will perform this task?
elecdaveAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

upul007Commented:
Is it just one email box on exchange? If so you could create an outlook account with internet email selecting the option to leave a copy of the message on server and export to excel. Then delete account.
Exchange offers extensive mail logging options. Did you look at these? One option creates text files and may be useful to you.
elecdaveAuthor Commented:
Thanks for the quick response!  

The purpose of my request is that we've enabled archiving on our Exchange server.  We're supporting 120+ mailboxes.
What I'm intending to do is archive a tape once a month which contains the mailbox which holds all the archived messages.  Then I'd like to keep a catalog in a database or spreadsheed of all messages stored on that tape for the month.   However, I'll only need the Subject, Sender, Recipient, Date_Received or Date_Sent.  I do not want to Export Content.

The reason why we are doing this is because we purchased the Exchange Standard Edition, and we are limited to Mailbox Storage sizes. We will reach the limit within six months if I don't periodically clean out the Archive mailbox.

So if I export to Excel as you suggested, it will also export the message content.  Is that correct?  
If you know if an alternate Exchange setting let me know.

Thanks
upul007Commented:
Yeah it will export the message content but that can be deleted off the excel file once done and used for reference later.

In Exchange > System Manager > Administrative Groups > First Administrative Group > Servers - right click and acess Server Properties.

In the General Tab - You should get options called

1. Enable subject logging and display.
2.Enable Meassage Trackin

Enable both. You can select the period as to how long you could keep the logs (I keep for 30 days, anything older gets deleted) You will see the log file path below.

Once this is done and you have data in the log files, open excel and import the file contents in to excel. This does not give the message content and far easier to get the data for reference later.

I would have suggested message tracking to refer the data but felt that you needed to store this separately. Give this a try. It gives the exact data you want for that spreadsheet.

Good luck.

Upul

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.