Solved

Receive structured email data and store to database

Posted on 2010-11-21
1
629 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
Comment Utility
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

Want to promote your upcoming event?

Attending an event? Speaking at a conference? Or exhibiting at a tradeshow? Easily inform your contacts by using a promotional banner in your email signature. This will ensure your organization’s most important contacts are in the know.

Join & Write a Comment

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

11 Experts available now in Live!

Get 1:1 Help Now