Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Thanked 0 Times in 0 Posts

    Automatically extracting data from email (2003)

    Is is possible to automatically extract data from an outlook 2003 email and place it into an Excel spreadsheet

    | (Embedded image Data Network Request System |
    | moved to file: Request For Service |
    | pic06543.jpg) Originated by Fred Smith on 17/10/2006 |
    | RFS Number: 0062/181006 |
    | Status: Supplier Solutioning

    In the above example email l would like the RFS number, Originated by name and originated date to be automatically imported into cells in an Excel spreadsheet, it would save me a lot of time and effort if this could be done.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 Posts

    Re: Automatically extracting data from email (2003

    Well, there is automatic when you open the message and click a button, and there is "unattended" automatic. For the latter, you can use the Rules feature, specifying an action in "Script." Actually it isn't script, you write a VBA (Visual Basic for Applications) procedure for either approach.

    It probably would be a few hours work to write the procedure and test it if you are familiar with VBA; much longer if you aren't. I won't elaborate on the details except to note that there are some past Outlook-to-Elsewhere solutions discussed on this board, on VB/VBA, and on the application boards (e.g., Access, Word).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts