[mystic7777]

I have this asp page (see code below). It grabs the values from the previous page and populates the email which gets sent to the recipient from the person bidding on his product. I need to grab the bidder's email address (he is logged in when sending this email) from the database. I can't seem to figure out the code for grabbing a logged in visitor's information from the database to display in the "From" field. Can anyone help? I need the code that grabs his email address, and the code that goes in the "mailer.from" variable to populate that field. Here's the code:

Code:

<%
response.buffer = true
message = "Someone has chosen to accept your bid."  & vbcrlf & vbcrlf & _ 
		  "Your BID ID"  & vbcrlf & vbcrlf & _
		  request.form("txtbidid")  & vbcrlf & vbcrlf & _
		  "Your Bid"  & vbcrlf & vbcrlf & _
                            request.form("txtbid")  & vbcrlf & vbcrlf & _
		  "Number of Shares"  & vbcrlf & vbcrlf & _
                            request.form("txtvalue")  & vbcrlf & vbcrlf & _
		  "Date and Time of your Bid"  & vbcrlf & vbcrlf & _
                            request.form("txttime")  & vbcrlf & vbcrlf & _
		  "IMPORTANT!!!"  & vbcrlf & vbcrlf & _
		  "Do NOT click on the link below until you and the seller have finalized your transaction."  & vbcrlf & vbcrlf & _
		  "Once you have, then click the link below to complete the transaction in our records and remove your bid from the database."  & vbcrlf & vbcrlf & _
		  "Thank you"  & vbcrlf & vbcrlf & _
		  "GTP123.com Level 2 Troptions Trading"  & vbcrlf & vbcrlf & _
"To complete this transaction, click the link below: " & vbCrLf & vbCrLf & "http://gtp123.com/autotest/completepurchase.asp?ID=" & Request.Form("txtid")
set mailer = server.createobject("CDONTS.NewMail")
mailer.subject = "An Offer For Your Stock"
mailer.from = "???????"
mailer.to = request.form("txtEmail")
mailer.body = message
mailer.send
set mail = nothing
response.redirect("thankyou2.asp") '<--Put your confirmation page here
%>