Solved

Receive structured email data and store to database

Posted on 2010-11-21
1
659 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

685 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