Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    importing from email (access 2003)

    I have a client who gets an email when a person registers for a class. Currently, she is printing the email and then entering the data into a database. Is there a way to automatically import the data from the email to access?

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

    Re: importing from email (access 2003)

    If the client is using Outlook, you could use Automation to read the e-mails and transfer data from them to a table in Access.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: importing from email (access 2003)

    They are using outlook so can you provide me with some details on how to do this? This is completely new to me.

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

    Re: importing from email (access 2003)

    For a general introduction to Automation. see WendellB

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: importing from email (access 2003)

    It is not very sophisticated, but it would be more efficient and accurate to copy and paste from the email, than print and retype.
    Regards
    John



Posting Permissions

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