I have a asp page called 'conf_booking.asp':
Code:
<%
Dim objCDOConf,objCDOSYS
Set objCDOSYS = Server.CreateObject("CDO.Message")
Set objCDOConf = Server.CreateObject ("CDO.Configuration")
With objCDOConf
.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "post.demon.co.uk"
.Fields("http://schemas.microsoft.com/cdo/configuration/sendusername") = "
[email protected]"
.Fields("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "*pAsSwOrD*"
.Fields.Update
End With
Set objCDOSYS.Configuration = objCDOConf
With objCDOSYS
.From = "
[email protected]"
.To = "
[email protected]"
.Subject = "Booking Confirmation - "&pnrno&""
.HTMLBody = "<html><h2>Booking Confirmation from "&agent_name&"</h2><p>This email has been generated automatically.</p><br><p>The status of PNR number: <b>"&pnrno&"</b> has changed to Confirmed</p><br><p>Lead Passenger: "&pass_forename_in&" "&pass_surname&"</p></html>"
.Send
End with
Set objCDOSYS = Nothing
'response.write "Email Sent....."
%>
This code will automatically send an email to
[email protected]. This line is here:
.To = "
[email protected]"
How can i create a form field in another table and store this in the MySQL DB so that this '.To:' field is populated with the correct email address?
i.e. the one that has been chosen and stored in the MySQL DB.
Picco
www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
CDO.Message form field
