asked on

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?

upul007

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.

elecdave

ASKER

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

ASKER CERTIFIED SOLUTION

upul007

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial