Here is a very basic example script for sending emails via CDONTS. This comes from the sqlmag web-site forum. Although fine, remember that it will use the local SMTP server to forward emails onto the destination user. If your servers smtp process can not reach an exchange/group-wise/other mail box on your network, then this code will not work. Look at coding your own VB COM object under the similar vein to easily change the destination smtp server.
Multiple file attachments with sp_send_dbmail