insert asp into an asp form script

[fran7]

Hi, Anyone know the way I could dynamically insert data in this form.

emailFrom = FilterCchar(FTGemailaddress)

objCDOSYSMail.To = "<rich33@hotmail.com>"

objCDOSYSMail.From = emailFrom
objCDOSYSMail.Subject = emailSubject
objCDOSYSMail.TextBody = emailBodyText
objCDOSYSMail.BodyPart.Charset = "ISO-8859-1"
objCDOSYSMail.Send

I am trying to insert the email address in this form from my database using
objCDOSYSMail.T o ="rsCard("PostC ardID")" of course this doesnt work but I dont know the method to write requests within asp or even if its possible

Any help would be great
Thanks
Richard

[DrBunchman]

Hi Richard,

Are you trying to assign the .To value of your mail object from a database? If so you can simply do as you have written in your post minus a couple of double quotes:

 objCDOSYSMail.To = rsCard("PostCardID")

This assumes that your record set object is still open and has not reached End Of File by this point.

If that's not what you're trying to do then I'm sorry I didn't understand it - could you explain it again?

Thanks,

Dr B