|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: retrieving e-mail addresses from a database and inserting into Bcc fields |
|
From: |
J. Paul Schmidt |
|
Date: |
6/5/2001 8:42:59 PM |
|
IP: |
205.188.192.58 |
Hopefully the following is somewhat similar to what you are asking:ASP News Letter by Faisal Khan
http://www.stardeveloper.com/asp_newsletter_1.asp
Loops thru recordset and sends an e-mail to each:
source
While Not rs.EOF
Set mail = Server.CreateObject("CDONTS.NewMail")
mail.From = "webmaster@yoursite.com"
mail.To = rs("email")
mail.Subject = subject
mail.Body = message & rs("email")
mail.Send
Set mail = Nothing
no = no + 1
rs.MoveNext
Wend
' When messages have been sent to all the users, exit
Response.Write "Emails sent to " & no & " users."
Best regards,
-Paul
J. Paul Schmidt, MBA
Databases on the Web
http://www.Bullschmidt.com
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
