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
from dbo.users
print @recipients
This will create a single string of users delimited with ;
Jeremy