>Well as I was told that the routine use to send E-mails to the clients is through Sql Server. The VFP app has no programs/routines that send out the emails and nor can I modified the app to include such routine. I examined the VFP codes and looked at the tables's properties to see if email is being send. Only place email is send is through the users's property. Thus, my question still remains is there a way on SQL Server, that I can use to send emails to the clients.
MS SQL Server has a component called SQL Mail that allows to send, recieve and process emails. It provides a set of extended stored procedures (SP) listed below:
sp_processmail
xp_sendmail
xp_deletemail
xp_startmail
xp_findnextmsg
xp_stopmail
xp_readmail
Email can be send by SQL Server Agent or by SP called from application.
See SQl Server Books Online for details.
--sb--