Insert records from email into access database

kfranck
kfranck used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Developer & EE Moderator
Fellow 2018
Most Valuable Expert 2013
Commented:
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.

Author

Commented:
Good suggestions. Thanks.
kfranck

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial