Export Email Header Script for Excel or Access

Posted on 2006-04-25
Last Modified: 2008-02-26
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?
Question by:elecdave
    LVL 17

    Expert Comment

    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.

    Author Comment

    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.

    LVL 17

    Accepted Solution

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now