I can drag and drop the Send Mail task in a dts package and use it to send
mail to a specific person and it works. The question is, how can I use it to
send multiple emails to various email addresses using a select from a table?
Anotherwords, how can I do a select from a table and use the result set to
populate the TO email address and send out to multiple email addresses?

--
Chris Davoli

Chris Davoli wrote:
Wouldn't it be easier to use use a (extended) stored procedure and wrap
this in a loop or cursor in T-SQL? See http://www.sqldev.net for a
reliable SMTP xp, xp_smtp_sendmail.


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