Storing and Categorizing Email into a DB

exvision

I'm hoping that there is a way to store and categorize emails from a POP/IMAP account into a MYSQL database.

My plan is to send a message from php with a project number embedded. When the recipient replies, the message would be categorized and saved to a DB.

Are there any methods to add a field to an email message?

I did a quick test by adding a mime header (ProjectNo: 1234) but when I send a reply the header isn't included.

Any ideas?

Thanks,

Anson

stolzyboy

you should post some code, then people may be able to help you better, i know we are geniuses, but we can't read minds, at least i can't anyway, LOL 😃

exvision

I'm still at the concept stage to tell you the truth. At the moment I don't know where to start. I'm more curious if there is a way to embed variables in an email.

I could always include the text ProjectNo: 3434 in the email. When the person replies that text should be included. Then search for the text ProjectNo: #### when inserting the replied email into the database. But that won't stop the recipient from deleting ProjectNo: #### in their reply.

So, I guess I am looking for a way to hide a variable that will be included in a reply.

Originally posted by stolzyboy
you should post some code, then people may be able to help you better, i know we are geniuses, but we can't read minds, at least i can't anyway, LOL 😃

majiclab

I don't think there is any fail-safe way to do this, but I often see e-mails where they say "hit reply to this message but do not change the subject line."

Other than that I don't think there is much you can do.

-Percy