How can i send email through a step in SQL Server...I tried using CDONTS but it gave me an error saying that the command script does not destroy all of the objects that it creates. Here is my email for loop right now it just sends me 2 emails if it works properly(got it to work in asp with no problem) but this is VB.:<BR><BR>for counter=0 to maxcounter<BR><BR>email=myarray(0,counter)<BR><BR> Set myMail = CreateObject("CDONTS.NewMail")<BR>myMail.BodyForma t = 0<BR>myMail.MailFormat = 0<BR>myMail.From = ""<BR>myMail.To = ""<BR>myMail.Subject= "Hi Tom, you got mail! -- Loads"<BR>myMail.Body = strbody<BR>myMail.Send<BR>set myMail = Nothing<BR><BR>next<BR><BR>Matt