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.
