Outlook email date and body to Excel RRS feed

  • Question

  • I've found quite a few vb codes that can move outlook contents (fixed fields) to Excel. I have following need:

    Each email is formatted few different ways, but fields along with data are still there, but not necessary in same order. I need script that captures anything after specified field (ie: Road Number: 1234 is same as Road ID: 5678 in different email) and also put the time stamp of email received date and senders name and email. Below is example

    Email 1:

    Jane Doe sanedoe@msn.com sent 12/12/12 20:08:01

    Body of the message:

    Road Number: 1234

    Condition: Good

    Submitter: Jane, D

    Email 2:

    John Doe john@msn.com sent 12/23/12 11:02:02

    Body of the message:

    Submitter: John

    Road ID: 5678

    Condition: Good

    I need excel to have all the columns and each email added as a row:

    Email by

    Email Address

    Sent On


    Road No


    Expert, please help! thank you!

    • Edited by Chinzo U Wednesday, December 19, 2012 3:23 PM
    Wednesday, December 19, 2012 3:21 PM

All replies