ASP form - update database record AND send email

[eghudak]

I have a form on my Intranet site that currently updates an Access database. It works fine. But, now I want to not only update my database, but also send an email to a recipient whose email address is dependent on what the user chose on the form.

FYI I have formmail for my cgi script.

How do I code my "Update Record" form button to not only update a record, but to automatically send an email?

 

[Tarwn]

In the same portion of your code responsible for sending the update to the database you can follow it with a CDONTS email.
For an already written example check out the FAQs : If I knew how to link to them I would, but heres the FAQ:
ASP 101 - p
Explains updating to a SQL Server database and then emailing the changes.
-Tarwn ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation