Did you get this to work as I am having the same problem. Hardcoding the 

recipient's email address works fine but I want to pick it up from a 

stored value in the e-mail field which appears on my registration form.



Can you please help if you have discovered a solution to this!?!



Thanks!>

> i have a very big problem.i am doing a web site for a company.in that 

one 

> part is.there is a registeraion form which has 4 

> fields.firstname,lastname,company name and email address.the user will 

> enter the details for all these fields and would click on the submit 

> button.all these data will be stored in the database.now what i want 

> is.there is a news letter which has to be sent to all these users who 

have 

> registered.there will be a page and a button.there is a central user who 

> when clicks on a button the file has to be sent to all the email 

> addresses.or atleast a notification has to be sent.the no.of users to 

whom 

> the message has to be sent will depend upon the no of email addresses 

> stored in the database.i would be very very happy if u could help me out 

> in this it is same as the procedure followed in this web page where u 

ask 

> the name and email address.and the notification will be sent in timely 

> basis.i want to do the same this.it is like the subscription u use in 

this 

> site.please help me in this regard.i would be very greatful.thank u.

You'll have to query your database and loop through the records.  Example:



'Assuming you have a recordset called objRS with the E-mail addresses in it

Dim objCDO 'as e-mail object

Set objCDO = Server.CreateObject("CDONTS.NewMail")



While NOT objRS.EOF

    objCDO.To = objRS("Email_Address")

    objCDO.From="whatever_you_want_here"

    objCDO.Subject="the subject line of the message"

    objCDO.Body="this is where your body of the E-mail would go"

    objCDO.Send

Wend



Set objCDO=Nothing





----- Original Message -----

From: "Sati Bedaysee" <sbedaysee@b...>

To: "ASP components" <asp_components@p...>

Sent: Monday, November 05, 2001 7:14 PM

Subject: [asp_components] Re: subscription





> Did you get this to work as I am having the same problem. Hardcoding the

> recipient's email address works fine but I want to pick it up from a

> stored value in the e-mail field which appears on my registration form.

>

> Can you please help if you have discovered a solution to this!?!

>

> Thanks!>

> > i have a very big problem.i am doing a web site for a company.in that

> one

> > part is.there is a registeraion form which has 4

> > fields.firstname,lastname,company name and email address.the user will

> > enter the details for all these fields and would click on the submit

> > button.all these data will be stored in the database.now what i want

> > is.there is a news letter which has to be sent to all these users who

> have

> > registered.there will be a page and a button.there is a central user who

> > when clicks on a button the file has to be sent to all the email

> > addresses.or atleast a notification has to be sent.the no.of users to

> whom

> > the message has to be sent will depend upon the no of email addresses

> > stored in the database.i would be very very happy if u could help me out

> > in this it is same as the procedure followed in this web page where u

> ask

> > the name and email address.and the notification will be sent in timely

> > basis.i want to do the same this.it is like the subscription u use in

> this

> > site.please help me in this regard.i would be very greatful.thank u.

>

>



arbon_reimer@h...


$subst('Email.Unsub')

>

>