lankapala
asked on
Reply email update database
When user send reply email , to specific email address, i need to update the Database value "yes"
if user reply user reply.
if user reply user reply.
EugeneZ
please provide details ..
ASKER
thank you for your email
i need to know without clicking on the email link, it's possible to update database table fields?
for example When user view on the email after if user reply email say Yes, i need to update "Yes2 word to database.
I can do that using add to the link in the email body. but it's not working out side the network.
so i'm looking for better solution.
i need to know without clicking on the email link, it's possible to update database table fields?
for example When user view on the email after if user reply email say Yes, i need to update "Yes2 word to database.
I can do that using add to the link in the email body. but it's not working out side the network.
so i'm looking for better solution.
You will have to play some tricks to get this working.
The 100% correct way will be to tag your sender address, so your sender address will look something like...
Where 35 is listid.
Where 343 is a msgid.
Where 5692 is a userid (email address reference).
When the reply comes into your MTA, write some glue code to parse updates+35+343+5692 then update the correct database field.
You will likely run into many problems with reply tracking.
First problem will be deliverability. Since all sender addresses are unique, clients will have to whitelist an entire domain, rather than sender address.
Second problem will be writing custom code, as most mail relay systems won't handle this very well. Most relay systems are built for speed, so you normally upload a list + send an email to that list... from a single sender...
Third problem, In your case, you'll have to relay on a per message basis, rather than a per list basis, so message deliverability will also be far slower.
Generally, reply tracking causes more problems than it solves.
You might consider hiring someone who works with large lists + describe exactly what problem you're trying to solve.
Most old dogs (people who've done this for decades) will likely have many work arounds which will achieve nearly the same goal, with no complexity or custom code.
The 100% correct way will be to tag your sender address, so your sender address will look something like...
updates+35+343+5692Where 35 is listid.
Where 343 is a msgid.
Where 5692 is a userid (email address reference).
When the reply comes into your MTA, write some glue code to parse updates+35+343+5692 then update the correct database field.
You will likely run into many problems with reply tracking.
First problem will be deliverability. Since all sender addresses are unique, clients will have to whitelist an entire domain, rather than sender address.
Second problem will be writing custom code, as most mail relay systems won't handle this very well. Most relay systems are built for speed, so you normally upload a list + send an email to that list... from a single sender...
Third problem, In your case, you'll have to relay on a per message basis, rather than a per list basis, so message deliverability will also be far slower.
Generally, reply tracking causes more problems than it solves.
You might consider hiring someone who works with large lists + describe exactly what problem you're trying to solve.
Most old dogs (people who've done this for decades) will likely have many work arounds which will achieve nearly the same goal, with no complexity or custom code.
ASKER
thank you very much any example much appriciated
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.