Bulk mail to subscribers (not spam)

Results 1 to 2 of 2

Thread: Bulk mail to subscribers (not spam)

  1. #1
    Join Date
    Dec 1969

    Default Bulk mail to subscribers (not spam)

    I have a rapidly growing (voluntary) mailing list that is in already excess of 40,000 recipients. When we send out the newsletter, it takes MULTIPLE HOURS to complete the send using a single database call and a loop which sends out a single message to each subscriber (creating and destroying the CDONTS object each time.<BR><BR>Is there a better way to send out mail to a large list of people?<BR><BR>[code language="vbscript"]<BR><BR>strSQL = "SELECT EmailAddress FROM Members ORDER BY emailAddress "<BR>set cnL = server.CreateObject("adodb.connection")<BR>cnL.Ope n myDSN<BR>set rsL = cnL.Execute(strSQL)<BR><BR>do while not rsL.eof <BR> Set objMail = Server.CreateObject("CDONTS.Newmail") <BR> objMail.MailFormat = 0 &#039;CDOMailFormatMime <BR> objMail.From = "address@domain.com"<BR> objMail.Value("Reply-To") = "address@domain.com"<BR> objMail.Subject = "October Newsletter" <BR> objMail.Body = "Greetings, subscriber!"<BR> objMail.To = "" & trim(rsL("EmailAddress"))<BR> objMail.Send<BR> set objMail = nothing<BR> rsL.movenext<BR>loop<BR>set rsL = nothing<BR>cnL.Close<BR>set cnL = nothing<BR>[/code]

  2. #2
    Join Date
    Dec 1969

    Default RE: Bulk mail to subscribers (not spam)

    Check out JMails&#039;s bulk mailer, or ASPQmail.

Posting Permissions

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