Chris N Rowlett
|
| Email and Microsoft Access integration - - This is a feature that I developed for another application so that email is automatically retrieved from the email server and saved in Microsoft Access tables. The feature automatically retrieves email from a POP 3 server every 5 minutes and saves the sender's email address, subject line, body, etc, into Access tables. The cool thing about this system is that as the application receives email, it triggers the Access database to perform actions for the user. If the subject line contains certain words, then the application does specific tasks. The system downloads the email from the email server and parses the data into the appropriate fields. We use specific subject and body tags so that Spam is disregarded under the assumption that it would be unlikely to have both subject and body tags identical to what we are using. We thought this was a better solution than to tie Outlook and Access together. |
Chris Rowlett
Other pages of interest Microsoft Access Email Integration Medical Insurance Audit Form System Legal Process Server Management and Tracking Purchase Order System For Home Builder Real Estate Business Management How to solve Rent Roll and USB Printer Problems
|