Unanswered: Any way to filter an email body into a mysql table field?
We have a local server that sends email notices with a uniform header when users have encountered a virus on their pc's.
I have been asked to see if there is a way to extract the body of the email and add it to a field in a mysql database. The body is only about 1 sentence long and contains the user name and if the virus has been identified, a virus name. They would like to be able to have this be something that will update itself with the only user intervention being a web interface to review the data. Not really sure where to start on this one, the web interface is not a problem, just extracting the email info and getting it into the database.
Can someone point me in the right direction here?