My friend has asked me to help him with his proposed email newsletter that people will sign up for on his financially-themed website. He wants to give recipients the option to stop receiving the newsletter with an "unsubscribe" link in the newsletter email.

What is the cleanest, easiest arrangement to let my friend receive the email addresses to be removed from his database?

My friend has asked me to help him with his proposed email newsletter that people will sign up for on his financially-themed website. He wants to give recipients the option to stop receiving the newsletter with an "unsubscribe" link in the newsletter email.

What is the cleanest, easiest arrangement to let my friend receive the email addresses to be removed from his database?

I take it if system is php or asp based. Your link will have his email id and user id . Just make a simple page where you can get this from url (userid and email address). And that code will update the status as not to send any more emails to this user or just deleet his record from your DB.

You can pay someone to do all this for you. There are plenty of companies out there that will manage your mailing list (including subscriptions and unsubscriptions). Might be easier than trying to do all that yourself, especially if you don't know what is required.

I've heard good things about Lyris. Never used it myself.

Agreed.

Aweber also gets excellent reports, and although it's a little more expensive I understand it's well worth the premium.

Hi...

I had the same problem as you have (or had :) )...but now that I do this for a living, I think I can help explicitly

Like it or not, you need to have a database, just to make it easier.
Try looking for programs like DesktopEmailer or SendBlaster.

This is because they have a database integrated and you don't need to write a php newsletter system.

The magic is in the "tags". These are used for personalization. Like when you have 10,000 customers and you want each of them to receive his mail with "Dear Mr (his name) (his lastname)".
You will never manually send 10,000 such mails.

Having that explained, you have to know that these tags can contain any text.

So just create an unsub link like this :

<a href="mailto:#thisisthetag#?Subject=Unsubscribe&Body=I want to unsubscribe">Unsubscribe</a>

and #thisisthetag# = your friends email (retrieved by the program - no effort from your side)

If you know a little PHP, you could parse the argument at the end of the link like this :

LINK :

<a href="http://www.sitename.com/script.php?mail=#tag#>Unsubscribe</a>

#tag# - customer's email (again, retrieved by the program)

PHP :

<?php
$mail=$_GET;
$subject = "Unsubscribe";
$text = "The customer with the e-mail address".$mail." wants to UNSUBSCRIBE from the newsletter";
mail('user@server.com',$subject,$text,"From: $mail <$mail>");
header("location:thankyoupage.html");
?>

Just save what's above in a script.php file.

thankyoupage.html = a page kept in the same directory with the PHP script

Cheers man!

Any questions, i'm <email snipped>

How about PHPlist?

Hi, i have been building my own newsletter script with the option of a "Opt Out" link at the bottom of each HTML Newsletter that is sent out.

This works perfect and I am sure you are required by law to include the option for opting out when sending newsletters.

I currently have hosting with godaddy, not the best as I have found out. But what they do allow is the ability to set up cron jobs that can send your email on a predefined time and day, 12oclock each week etc.

What you need is
1> a database
2> script to obtain subscriptions
3> your newsletter template (html)
4> your cron job creating (php script)
5> your opt out link in each email

If you wanna know more or you would like to hire me for a few hours, reply here and we can discuss in more detail.

I recommend to check out Gold Lasso, Bronto, and Constant Contact for email management. I also recommend you to become familiar with CAN-SPAM rules.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.