Hello All- Using a national hospital database, I need to email specific nightly reports to the correct hospital site from and email table within the database using SQL. Is this possible? If so, how do I begin this process? The database is already conifgured and runs the reports nightly. Reports are hospital specifc and need to be sent to only the specifc hospital. The database has a table containing hospital site IDs (which match the reports) and emails from which it can query the information needed for each specific report. Thanks
Welcome to the forums. Not sure the version of SQL Server you are using, if it is 2005 or above then you can take help of Database Mail in thsi regard. See See http://msdn.microsoft.com/en-us/library/ms159218.aspx & http://msdn.microsoft.com/en-us/library/ms160334.aspx links for more information. Also in this site search under articles for such information.
