Email to Database
Posted on 2012-09-17
I have a MS-Exchange emai account that gets email alerts for status changes to projects we are working on.
I want to take these alerts and put them into a DB so I can report the status via a web site.
I am not really sure where to start but I thought the first thing to do is parse the email into a Database, I have MS SQL 2008.
Here is an example of the email body.
Location: MyStore #7536
Requested Service: Time Clock Install
PO#: Per Rick
Scheduled ETA: 9/12/2012 4:00:00 PM
Check in: 9/12/2012 2:00:00 PM
Check out: 9/12/2012 4:00:00 PM
Progress - Resolution Notes:
Technician reports site is completed. Technician installed 2 new time clocks and worked with Sherry from support. Technician confirmed with Sherry that both are working with no issues. Technician took pictures and will be sending them over shortly.
There are several alerts that I get, and the subject line will say which kind it is, arrival alert, departure alert ect....