Ilan,

I think what you want to do it to create a single variable with a list of users and then set that as @recipients.

Try this:

declare @recipient varchar(1000)

set @recipient = ''

select @recipient = @recipient +

case

when @recipient > '' then ';'

else ''

end

+ EMAIL

from dbo.users

print @recipients

This will create a single string of users delimited with ;

Jeremy