i dont get what u have replied

This is one of the rare scenarios where you'll have to use a loop and iterate through every distinct user.

Assign the mail addresse to...

i realized i posted my question to sql 2005 tthats why i posted here as well. Its not a floooood:hehe:

It was too early to say it is working!!

When I add below to my code:

DECLARE @recep varchar(500)

SET

@recep= (SELECT email

FROM

dbo.mytable

)

Now i can send email to variable...

It worked for me. I sorted out by myself.

But thanks for your reply:-)

It worked for me. I sorted out by myself.

It worked for me. I sorted out by myself.

I'm using sql2008

I'm also having similar issuer. I have below codes but i'm not sure how to define variable emails from same table

use

db

go

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML =

...