Solved

Receive structured email data and store to database

Posted on 2010-11-21
1
647 Views
Last Modified: 2013-12-25
Hi,
within our Web framework, there are forms that will be mailed to certain mail distribution lists (Outlook Exchange).
These emails contain structured form data as follows:

fields 1: value1
field 2: value2
...

Is there a simple way to transform these emails to a database structure (incoming email will trigger a small process that converts this email data and stores it to the database).

BR
0
Comment
Question by:go4java
1 Comment
 
LVL 13

Accepted Solution

by:
gbanik earned 500 total points
ID: 34183737
This is one of the best articles on this subject
http://www.outlookcode.com/article.aspx?id=25
Follow it to directly connect to your own DB

To trigger the process you could use the NewMailEx event of Outlook

By the way, for some reason if you want a ready product... try this
http://www.egrabber.com/wrgbiz/
Too big a product for you though. I suggest follow the above article... it has sample codes to assist you towards your goal.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

832 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