Bulk email and CDONTS

[Javamahn]

I am selecting a recordset based on a field("emailed&quot = False. The Multiple records are then displayed,in a form with the addition of a "Send email" checkbox. the checkbox has a value equal to the ID# (autonumbering Primary key) of the record. I want to allow the user to select which records in the recordset to send an email to using cdonts. I believe subset is the proper term and then update the database changing the field emailed to true when the form is submitted. Recordset selection is easy. After that I am lost. Any help is greatly appreciated.

 

[snowboardr]

You need to explain it better. www.vzio.com
ASP WEB DEVELOPMENT

 

[denoxis]

C'mon snowboardr you answered this before.

Request the checkbox values that has the ID#s. (When you use one name for all checkboxex you'll receive the data comma delimited.) Example:

userIDs = request.form("checkbox_name&quot
set rs = conn.execute("select * from users where ID in " & userIDS)
userInfo=rs.getrows
rs.close : set rs = nothing
for i = 0 to ubound(userInfo,2)
set cdonts ' pseudo code
cdonts.to = userInfo(2) '
send email '
set sdonts = nothing '
next

 

[Javamahn]

Thank you denoxis. I did not know the data was passed comma delimited. That makes it much easier.