E-mail question

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.

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

Code:

---

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.

Hey thanx that worked out great!