How to trigger an event that causes an email to be sent?

Is there any way for an email to be sent out when data is saved to a database?

This would be an appointment entered on an html/coldfusion calendar with sql 2000 on the back end, Windows 2000 server.