Please can anyone guide me on how to create an e-mail subscribe and Unsubscribe link on my website. I want to be sending e-mail to people and want them to unsubscribe at will.
Thanks

Here's a quick and dirty way, assuming you hv the emails stored in a database:

1) Your unsubscribe link cd look like so: www.mbeki.com/emails.php?id=(id column of email in database)&unsubscribe=y

2) When the person clicks the link, of course taking care of sanitizing the input (for example, ensure that id is a number, etc), you store the id and unsubscribe values.

3) You then run an update on the email table, setting unsubscribe to Y where id = the id of the user

That should do it. good luck!

I actually configured the e-mail with MS Outlook. What database are you talking about. i seem to be confused here.

hmmm, now I am confused to. Not good

You mentioned a website at first, not any configuring with outlook. Outlook can't unsubscribe you at all. At best, you can create rules for redirecting certain emails to certain folders. To actually get your name off of a list involves purging your record from a database, hence my response.

hmmm, i am still confused, then again, it takes very little to get me confused

yawa you are doing a great job.

its like teaching Physics in Nursery school sometimes. weldone

Thanks

its like teaching Physics in Nursery school sometimes

Is this good or bad? 

yawa-ti-de:

Thanks
Is this good or bad?

I think its child abuse.

It is not child abuse at all. Because you know doesn't mean that others must know and it is not the way you learn that others do. I've seen people that I even give the actual codes to their problems and they still don't get it to work until I code the entire page up for them and upload online. Sometimes you don't blame them but that depends on the task in question and they person too concerned. He might be ready to learn but the atmosphere might be too tensed for him. When all is condusive, that moment I think all tutorials will be well understood and integrated.

try using phplist,its free and open source and can easily be installed on your existing website

emaginate:

try using phplist,its free and open source and can easily be installed on your existing website

Now that sounds less like child abuse

Question(s):

Assuming these email addresses are collected via a form, so the poster should then maintain 2 databases/tables, copying from one to the other? Isn't this double work?

lol @ onye_ngbu, which one be child abuse again?

I think Mbeki is trying to connect his Microsoft Outlook list with that on his website.

That cannot be done as far as I know (but anything can be possible these days since the web came around).

You would have to choose between manual creation on outlook and automatic subscription on your website.

For automatic subscription, try yawa-ti-de's logic or phplist as someone suggested. If its too tough for you, hire a coder.

Olawunmi,
Hostmot Sales Rep. (www.hostmot.com)