• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

Insert records from email into access database

How can I get an email message on IMAP google account to insert into an access database? The user will send an email to a google email group (say Help@mybusiness.com) and I want the email to be inserted into an Access database using ASP.

Suggestions on coding this? Thanks.
1 Solution
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
First you have to read your email and it is possible your email server for mybusiness.com may have something you can use or perhaps your hosting company if shared, already has a component installed.   If not you can get http://www.aspemail.com/  It is free.  However, the portion you need requires the paid version http://www.aspemail.com/manual_08.html.    

There is another component talked about in at 4guys from rolla that is less expensive.  

Basically you are going to log into the pop3 server, read an email, update to the database and loop.  The 4guys article has a good example.
kfranckAuthor Commented:
Good suggestions. Thanks.

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now