ASP solution for bulk email list (opt-in)

Results 1 to 2 of 2

Thread: ASP solution for bulk email list (opt-in)

  1. #1
    Chris D. Guest

    Default ASP solution for bulk email list (opt-in)

    I&#039m searching for a solution to use ASP and Access as the data recepticle for user information and email addresses for an opt-in email list. Scott Mitchell had an example of SQL-server on the backend. Any leads would be most appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: ASP solution for bulk email list (opt-in)

    It&#039s really pretty easy:<BR><BR>&#060;%<BR>&#039Create your recordset<BR>set rs = Server.CreateObject("ADODB.Recordset")<BR><BR>&#03 9Open the recordset selecting all email addresses from the <BR>&#039EmailAddresses field<BR>rs.Open = "SELECT EMailAddress FROM Visitors", "DSN=JobBoard"<BR> <BR><BR>do while not rs.EOF<BR> set objEMail = Server.CreateObject("CDONTS.NewMail")<BR> objEMail.To = rs("EMailAddress")<BR> objEMail.From = Request("txtFrom")<BR> objEMail.Subject = Request("txtSubject")<BR> objEMail.Body = Request("txtBody")<BR> objEMail.Send<BR> set objEMail = nothing<BR> rs.MoveNext<BR> loop<BR> rs.Close<BR> set rs = nothing<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts