Hi Folks,
First post here if this is in the wrong section do forgive me 🙂
I'm wanting to pipe email for certain email addresses into a mysql database so that emails can be answered via a web-front end for easy tracking.
I'm trying to figure out howto get get the email to be picked up via the script and inserted into the mysql database.
I figure I'm going to have to edit my alias file for email to point at the script but how do I go about programming a script to break it down so the database collects the email headers, subject line, email address and all the other relevant information that maybe needed for tracking purposes.
What would be the best way of tracking the emails? would it be best to assign it a id? well that can the table number but how would i make any follow up emails with that same subject line or message number link up?
Any help and advise would be welcomed. If I can be more descriptive let me know.