logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
European Travel
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel


dailyclick
All times in EST

Low Carb: 8:00 PM

Full Schedule
g
g ASP Site

BellaOnline's ASP Editor

g

Sending Out an ASP Newsletter Mailing


If you have created a database full of email addresses for your newsletter, you'll want to send weekly newsletters out to that group. Here's how.

First, be sure to read Getting Subscriptions to your Newsletter. This will help explain how to get your membership subscribers, including checking the email addresses for problems and sending out a thank-you note.

So now you have a database table, let's call it MEMBERS, full of email addresses. You want to be able to send a newsletter out.

Create a form on a webpage that lets you enter the title and content of the email message. That way you can use this form each week to send out your newsletter to your faithful visitors.

On your processing page, take in the two variables:

NLSubject = Request.Form("nl_subject")
NLText = Request.Form("nl_text")

Now it's time to start cycling through all the database members and sending each person their very own newsletter.

Set objRec3 = Server.CreateObject ("ADODB.Recordset")
SQLText = "select email from members"
objRec3.Open SQLText, strConnect, adOpenForwardOnly, adLockReadOnly, adCmdText
While Not objRec3.EOF

Okey dokey, you're in the while loop. This is where we do the actual mail send.

set objMail = CreateObject("CDONTS.NewMail")
objMail.BodyFormat = 1
objMail.MailFormat = 1
objMail.From = "webmaster@yoursitename.com"
objMail.To = objRec3("email")
objMail.Subject = NLSubject
objMail.Body = NLText
objMail.Send
set objMail = Nothing

Message is sent! Now just move on to the next record and keep looping through the names until the end.

objRec3.MoveNext
Wend
objRec3.close()
set objRec3 = Nothing

Pretty simple! Don't forget to give your members a way to unsubscribe easily from your newsletter, so that you aren't accused of being a spammer!

Introduction to ASP Ebook

Download this ebook to get everything you need to know about learning ASP - from a step by step tutorial to function lists, sample code, common errors and solutions, and much more! 101 pages.
Add Sending+Out+an+ASP+Newsletter+Mailing to Twitter Add Sending+Out+an+ASP+Newsletter+Mailing to Facebook Add Sending+Out+an+ASP+Newsletter+Mailing to MySpace Add Sending+Out+an+ASP+Newsletter+Mailing to Del.icio.us Digg Sending+Out+an+ASP+Newsletter+Mailing Add Sending+Out+an+ASP+Newsletter+Mailing to Yahoo My Web Add Sending+Out+an+ASP+Newsletter+Mailing to Google Bookmarks Add Sending+Out+an+ASP+Newsletter+Mailing to Stumbleupon Add Sending+Out+an+ASP+Newsletter+Mailing to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the ASP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Lisa Shea. All rights reserved.
This content was written by Lisa Shea. If you wish to use this content in any manner, you need written permission. Contact Lisa Shea for details.

g


g features
Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor