Bulk Email to Individual Email Recipients

  • Thread starter Thread starter Joe W
  • Start date Start date
J

Joe W

I would like to email from a web page to a list of email recipients.

However, I would like to send each as an individual email so that the
list of recipients does not appear on each individual recipient's email.
I would also like to do this with out pressing send for each email. I
have almost 100 recipients.

I'm self taught between the beginner and intermediate level of
understanding. Hopefully closer to the intermediate level.

Thanks

Joe W
 
You don't mention what platform the web page is running on. But since you're
looking at Microsoft newsgroups I'm going to assume that you are using IIS
and ASP. Further, I'm going to assume that the eMail addresses are contained
in a database of some sort. If so then the solution to your problem is to
open a Recordset of the eMail addresses and loop through it sending an eMail
each time through. Something like this in ASP code:

<%
Dim oConn
Dim oRS
Dim oMail

Set oConn = Server.CreateObject("ADODB.Connection")
Set oRS = Server.CreateObject("ADODB.Recordset")

oConn.Open "your_database_connection_string"
oRS.Open "SELECT eMail FROM your_table_name WHERE your_criteria"

Do Until oRS.EOF
Set oMail = Server.CreateObject("CDONTS.NewMail")

oMail.From = (e-mail address removed)
oMail.To = oRS(0)
oMail.Subject = "Your Subject"
oMail.Body = "Whatever you wanted to send."

oMail.Send

Set oMail = Nothing

oRS.MoveNext
Loop

oRS.Close
oConn.Close

Set oRS = Nothing
Set oConn = Nothing
%>
 
Back
Top