Solved

Insert records from email into access database

Posted on 2011-09-02
2
275 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:kfranck
2 Comments
 
LVL 52

Accepted Solution

by:
Scott Fell,  EE MVE earned 500 total points
ID: 36477249
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.
0
 

Author Closing Comment

by:kfranck
ID: 36477840
Good suggestions. Thanks.
kfranck
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now