Solved

Insert records from email into access database

Posted on 2011-09-02
2
276 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
API not working 33 57
Live mode in DW, need to creae Session 4 79
Calculating value of records from a column - classic asp 7 70
Summernote and form validation 10 103
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

27 Experts available now in Live!

Get 1:1 Help Now