Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2001-08-05 : 14:23:50
|
| I need to e-mail about 90 people once a quarter to remind them to complete a task using SQL Server. All of the people, all of the tasks, the due dates, etc are all in SQL. I want to run a small stored procedure to generate a custom list of tasks per person and then e-mail it to them.What's the best way to do it? Should I set up a temp table of people to e-mail, loop through the table running the SPROC and using sp_sendmail? Any advice appreciated. |
|
|
|
|
|
Best way to e-mail a group from SQL Server