> I want to use an Execute SQL Task to load an email address list from a
> table and use the variable as the TO field in the Send Mail Task. Got
> the list into a variable okay, but can't figure out how to make it
> work as the TO in Send Mail. Any ideas?
>

"Allan Mitchell" wrote:

> Hello Arghknork,
>
>
> Have a look at these articles and you should get the idea.
>
> How to loop through a global variable Rowset
> (http://www.sqldts.com/default.aspx?298)
>
>
> Changing the DTS Send Mail Task
> (http://www.sqldts.com/default.aspx?235)
>
>
>
> OR
>
>
> Shredding a Recordset
> (http://www.sqlis.com/default.aspx?59)
>
>
>
> Allan
>
> > I want to use an Execute SQL Task to load an email address list from a
> > table and use the variable as the TO field in the Send Mail Task. Got
> > the list into a variable okay, but can't figure out how to make it
> > work as the TO in Send Mail. Any ideas?
> >
>
>