How to check that an email has been opened ?

Well I have some CFs sending email with a template with images.

I would like to attach a link back to it in order to record if the email has been read or not.

Something on the model of acymailing

<img alt="" src="http://mywebsite.com/index.php?option=com_acymailing>ask=stats&mailid=10&subid=1"  border="0"  height="1"  width="50" />

Is there any way to do it with CF ? I mean a link back which would record something in the table that I choose, with a counter to increment it and the ip from which it originated.

Basically I would like to check that my customers have received the stuff correctly because the products are bouqht by a third party and there is no way to check the recipient email.

I can attach a unique identifier to the image and set a link back to CF, but what to do next and how to make that CF will automatically record something ?

Hi alterna,

I've never done this but I think it should work.

Create a form that will get the id from the URL and then save it to the database using a standard DB Connection. The form needs no Form HTML and you need to include &task=send in the URL. That should work without anything much else, run a quick test and see if it works.

There are problems of course, mostly that some email readers don't automatically download images :-(

Bob

I will test.
Can I write to an existing table or do I have to make a new one ?
I mean at each run of the url what will happen to the table ?

Hi alterna,

You can write to any table. But be careful which one you choose.

You will need to create the MyQL and PHP to make whatever change you want to record - no necessarily helpful but true.

Bob