We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

Members

Technology Zones

Articles

Hosted By

MaximumASP

Info
Rated
Read 22,051 times
5 comments

Contents

Downloads

Related Categories

Creating a Newsletter system - Introduction

PVarando

Introduction

This tutorials will show you how to create a fully automated system to allow visitors to subscribe and unsubscribe to your newsletter. It also shows the administration panel to mass mail all members. Let's Begin:

Here's what's involved.
1) Create the database
2) Create a page for people to sign up.
3) Create a page to unsubscribe.
4) Create a page to send newsletter.

First, lets create the database. Create a table called: Newsletter. Next, create the following fields.

Field Name Field Type
MemberID Autonumber
Name Text
Email Text
EmailType Number

Once you have created the database, create a DSN pointing to the database by going to Data Sources (ODBC) in Administrative Tools on Windows. Now we need to create the actual pages...

I've been around computers ever since I could remember, The first time I toyed around with a computer, I was about 3 years old. I ran my own BBS service in Miami from age 7 to 13 and I found it very interesting. The internet then began to emerge and that's part of the reason I stopped the BBS access. I've been creating web sites for over 6 years. Before then I was building and repairing computers for fun and profit. I was born in Buenos Aires, Argentina on February 20th, 1978. You can learn a little more about me and my family by visiting my personal home page. I enjoy programming and designing graphics using programs such as Photoshop, Paint Shop Pro, and Bryce. I've enjoyed many different types of computer jobs, but web development is my absolute favorite. I enjoy building a web site and seeing it evolve into a full living site. I say living because that's how I look at a site, if you don't nurture it, maintain it, and from time to time re-dress it, it grows cold and eventually dies. Now that you know a little about me, let me hear from you, you can contact me at: webmaster@cfm-resources.net

Get FREE ColdFusion Hosting at: http://www.cfm-resources.com

Comments

Read Comments | Post Comment

  • Re: [1948] Creating a Newsletter system

    Posted by Jbuda on 23 May 2006

    Try using 'GTE' as opposed to 'GTI'.

    Its supposed to mean Greater Than or Equal to.

  • Re: [1948] Creating a Newsletter system

    Posted by 7vinyls on 13 May 2006

    Hi, could anyone help me with this? Im getting an error on the unsubscribe page to do with the GTI line. Its pretty new to me and im not even sure what this line means!!!



  • quick question

    Posted by cralph on 22 Jan 2003

    I'm new to the web scene but need this script to work. Please let me know how I put it in. Is it in the body. Are they seperate pages?
    Can you make this dummy proof for a beginner like me.

    Thanks ...

  • questions on newsletters

    Posted by ak11 on 14 Jan 2003

    Hi i am new in creating newsletters and i would like to ask you.This code you submit enters in the section.I tried to put it there but in the PREVIEW i see nothiing but plain text.
    Plea...

  • RE: Message variable error

    Posted by psfong on 11 Jul 2002

    If you have notice, the sample code here does not have a field 'message' in the database. Maybe you can add in the field for 'message', or you can have a form before that to input all the email messag...