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

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?
0
elecdave
Asked:
elecdave
  • 2
1 Solution
 
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.
0
 
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
0
 
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
0

Featured Post

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!

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