how do i send a record link with my form mail below i have the database and when a form is filled it sends a mail to me , i want the link to the record of the user to be sent to me so that i can click and a page with the users details is loaded from database. ? what link should be in the .Textbody

Sub SendRequestMail()

Dim objMail, objMailConf
Set objMail = Server.CreateObject("CDO.Message")
Set objMailConf = Server.CreateObject("CDO.Configuration")
'objMailConf.Fields.item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 1
'objMailConf.Fields.item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "192.168.230.10"
'objMailConf.fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
'objMailConf.Fields.item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10
objMailConf.Fields.Update
Set objMail.Configuration = objMailConf
objMail.From = "[email protected]"
objMail.To = "[email protected]"
objMail.Subject = "testing form"
objMail.TextBody = "This is the link ........ (forum help)...... "

objMail.Fields.Update
objMail.Send
Set objMail = Nothing

Create a page consists of two functions; inserting user info into database, and another is sending user ID link via e-mail to you. Is that what you want? Cheers.