Using SQL Server 2005 to send database email based on a quer

[z064life]

I am making a database with SQL Server 2k5 and a frontend in C# forms.

My client (a friend) wants me to add functionality that allows alerts to be sent to him and the client of when their contract is expiring.

The scenario is a phone shop, which he owns. If the client took out a 18 month contract, then he would like an email sent on the 17th month of that contract (1 month before expiry) alerting him, and also an email sent to the customer alerting him or her.

What is the best way to implement this?

Thanks

[pdV6]

http://msdn2.microsoft.com/en-us/libr