Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extracting Data (Outlook 2000/2003)

    I have a formatted email we receive.
    Record code: PFP,PFR,

    DM's Name: BRETT JENS

    [Name Section]
    ************************************************
    First Name: Michelle
    Middle Initial:
    Last Name: Smith
    Sex:
    Social Security Number: 333224444
    Marital Status:
    Date of Birth:
    Race:

    [Address Section]
    ************************************************
    Street:
    City:
    State:
    Zip:
    Phone:

    [Job Section]
    ************************************************
    Store: 4162
    Store/City Location:
    Store/State Location:
    New/Rehire:
    Job Title: Assistant Manager - Store
    Reg/Temp:
    Full/Part:
    Rate: $0.00
    Rate Type: Hourly
    Start Date:

    Is there a way to extract data from this email using Access / Outlook automation?

    I know that I can exprot the folder to Access and then use text parsing to get the data,
    I was hoping for a more elegant solution.


    Thanks for your help.
    Richard

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Extracting Data (Outlook 2000/2003)

    Whether you export to Access or use Automation, you'll have to parse the text to extract the information from it. There is no one-step transformation.

Posting Permissions

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