You can go through help in SQL Server(if using sql server) Books on line about SQL Mail. That can be an ideal way to do it, if you wanted to trigger this from the database server.
Or
If you are trying to do this from frontend, somthing like ASP, you can go through articles about CDONTS. Once you decide to do that from frontend, you can pull in data from sql server and compose mails prgramatically and send them out using CDONTS for which you should be having SMTP server configured on you server that hosts you web pages. I dont have any examples to post you right now. Will let you know, if I find any, meanwhile you can go through the articles/help on the above said.
Cheers!
-Vijay G
|