Automatic Email From SQLServer in ASP?

I have a webpage that is connected to an MS SQL Server database. From the webpage you can add, delete or edit records from the database. Is it possible to send an automatic email when a certain field is populated in the database, if so how can I do this? Thanks is advance!