A while back we found a Stored procedure on the net from MS that allowed you
to send mail.

We used this SP in a few of our DTS jobs. We have a Table that we enter in
all of the emails that we want the system to generate for us. Then loop
through all the non-processed emails and send the info to
sp_send_cdosysmail.

I know there is a Send Email Task, though How can send a set of records to
it or a script to go though all the rows that need processing?

Would I be better off just sending the rows to a script and then sending the
mail via VB.Net and not using the Send Mail Task?

Thanks,
Scott<-

Scott Townsend wrote:

To drive a loop off a table, get the data into a variable using an Exec
SQL Task, results as full row set. Then For Each Loop with the ADO
enumerator to get the values out and split them into variables for use
within the loop.

I would actually skip this and use pure T-SQL all the way. I'd use
sp_smtp_sendmail and call that within a loop inside a single T-SQL
batch. It is reliable and easy to use.


--
Darren
http://www.sqldts.com
http://www.sqlis.com