E-mail question

[Jasone]

I have a form on a website that posts to an SQL database, what I want to be able to do is post it to the database and email that post to me whenever one is added. Any help would be appreciated.

[jdavison]

If your using asp you could submit that info into a new asp page which would handle the database insert and then add the code below

Set objmsg = Server.CreateObject("CDONTS.NewMail")

objmsg.From = "email from address"
objmsg.to = "email to address"
objmsg.subject = "subject for email"
objmsg.body = "message body"

objmsg.send

this code will have to run on an NT machine since it uses CDO for NTS.

I hope this helps you.

[Jasone]

Hey thanx that worked out great!