Hi all,
Visitors can contact staff by means of contact form (visitor needs to submit
email as well). This will be stored in DB. Now considering that staff responds to this message, the reply from the staff would be sent to the visitors
email directly. Say if the user wants to follow up on the message sent by the staff, I would like the visitor to just hit the reply button in his
email service & send me his questions on the same topic, but just retain the ID in the Subject line. So when the visitor send this
email, I would like to receive the
email & at the same time, try to search in my DB if the ID that is present in the
email subject, actually exists in the system. If yes, that would be sent back to the same staff member who handled the response previously or it would be assigned to a new staff member.
That being said, I was thinking of how to do this. The part where I am really held up is when the staff receives the actual
email from the visitors
email, how can I check the DB? Say I am/staff is receiving emails at
[email protected]. When visitor sends reply
email, then it would be sent to
[email protected]. How can I check to see if the ID in the subject line of the
email that I received at
[email protected], actually exists in my DB in my website? This is where I am really stuck.
Looking forward for your replies. Thank you.
