Post to Email and Database

Figured it out:

objNewMail.Subject = "Thank you " & request.form("field1") & request.form("field2")

New question:

What I would like to do is put the ID in the subject. I tried objNewMail.Subject = request.form.("id") but when the email is sent the field is blank. When a new entry is saved in the database it will automatically generate a new id#, how can you pull that new id# and show it in the email? Not sure what it is that I am doing wrong here.

Thanks in advance.

That is pretty much what I was doing.  My script is the following:

rsAddListing.Update

intIDNumber = request.form("id")

Dim objNewMail
Set objNewMail = Server.CreateObject("CDONTS.NewMail")
objNewMail.From = ********@*****.com
objNewMail.To = request.form("email")
objNewMail.Subject = "New Listing #" & intIDNumber
objNewMail.Body = "This is the body of the test email."
objNewMail.Send
Set objNewMail = Nothing

rsAddListing.Close

Set rsAddListing = Nothing
adoCon.Close
Set adoCon = Nothing

But all I get in my subject line is "Listing #"

I tried @@identity but couldn't get it to work either.  Please help - frustration starting to kick in.

ljamal I tried your suggestion and got the following error:

 Microsoft VBScript runtime error '800a01a8'

Object required: 'sAddListing'

/postnewlisting.asp, line 72

Bunce, I am using MS Access 2002.  What is it that I am doing wrong?

 

Tried you suggestion with no luck.  Thanks for trying though.