ASPMailer - Create Mailing List

Question

I have a list of users with name and email address. I want to
be able to use the following code (aspmail) to select the emails
from a database in groups of 20 and have a period of 10 seconds in
between groups of 20's. How can I modify the following code to do
so. I have a lot of emails so I have to make sure that the script
doesn't time out and finish sending the email to all my database.

I'm using asp/vbscript with access. Please advise.

<%
Set Mailer = Server.CreateObject("SMTPsvg.Mailer")
Mailer.FromName = "Joe’s Widgets Corp."
Mailer.FromAddress= "Joe@somehost.com"
Mailer.RemoteHost = "mailhost.localisp.net"
Mailer.AddRecipient "John Smith",
"jsmith@anotherhostname.com"
Mailer.Subject = "Great SMTP Product!"
Mailer.BodyText = "Dear Stephen" & VbCrLf & "Your
widgets order has been processed!"
if Mailer.SendMail then
 Response.Write "Mail sent..."
else
 Response.Write "Mail send failure. Error was " &
Mailer.Response
end if%>

DLoe · Answer

I've approached the issue of a "timer" for various functions on different project, and my super-advanced programmer says there's no such function in ASP. I've looked and haven't found.

As for the issue of pulling 20 addresses at a time from the database, look up the following:

FOR loops

Here are a few tutorials I found:
http://www.freewebmasterhelp.com/tutorials/asp/4
http://www.w3schools.com/vbscript/vbscript_looping.asp

Of cours, you'll also have to repeat a 1-20 count, and start at the last read record, so it could be a little tricky.

I'm sure I haven't given you the full answer, but I hope this gets you started.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded