• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 677
  • Last Modified:

Receive structured email data and store to database

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
go4java
Asked:
go4java
1 Solution
 
gbanikCommented:
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

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now