Automatically save contents of e-mail into a table in a database

[Funkymonkey]

Any ideas how I would go about automatically saving the main body of an e-mail into a database????

Thanks for any suggestions!

[takkie]

Any ideas how I would go about automatically saving the main body of an e-mail into a database????

Thanks for any suggestions!

just save the eml into the db as binary..

[Funkymonkey]

No it needs to be automatic

[takkie]

No it needs to be automatic

what do you mean by automatic? there has to be some sort of trigger, right?

like, after a user submits a form, and then behind the scene, it will store the contents into somewhere automaticall, right? if that is the case, then just save the contents into the db...

OR

unless you are talking about, have an engine running 24/7, and constanting parsing data from email into the db. If this is what you are talking about, may I ask you what type of email server is it going to integrate with?

This is what I have done in my past experience, someone sends an email to someone@something.com, and then i wrote an engine (windows service) that checks that account in a certain time period, and if tehre is an email and it must be in certain predefine format (like, Firstname: Lastname: Address; Zip:...etc...), parse the contents and dumb it into the database according a certain schema that we have setup (for field mappings)...

is this what you are talking about?

- Tak