View Single Post
  #1 (permalink)  
Old July 23rd, 2005, 11:39 AM
p2ptolu p2ptolu is offline
Authorized User
 
Join Date: Jan 2005
Location: ipaja, lagos, Nigeria.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to p2ptolu Send a message via Yahoo to p2ptolu
Default sending record links from form

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@email.com"
objMail.To = "xxx@yahoo.com"
objMail.Subject = "testing form"
objMail.TextBody = "This is the link ........ (forum help)...... "

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