Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    email (2003 Professional)

    Is there some way to extract data from an email and entering it in a table. ie: If I wanted to make a database of armed forces personnel with fields "Name" "Rank" and SN" for example, and extract that info from an email and enter it into a data base. The info would come from a form on a web site, so the form setup would be the same on all received emails.

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

    Re: email (2003 Professional)

    The general answer is yes, but the actual implementation depends on how the data occur in the e-mail. For example, is Rank always on the 2nd line, or does e-mail contain the text "Rank: Lieutenant" (or whatever), or ...

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: email (2003 Professional)

    The field names "Rank" etc would always be located in the same place. The entered info would be contained within Quotation marks.

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

    Re: email (2003 Professional)

    Assuming that you use Outlook, you'd control it from Access using Automation. You can loop through the e-mails in a folder and look at their Body property. This is an unformatted string representing the message text of the e-mail. You can use functions such as InStr to parse the string.

    If you're not familiar with Automation, see WendellB's tutorial Automation 101.
    Search this forum for Outlook.Application to see examples of automating Outlook from Access.

Posting Permissions

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