How Access Records One By One Fetched Using Select Query In Sql Server 2005

Hi Friends,

I have created the procedure in sql server 2005 for retriving email addresses from table based on date_expiry and concatinating all email addresses in to @tolist  as shown below

Declare @tolist varchar(8000)

set @tolist = ''SELECT @tolist = @tolist + ';' + COALESCE(email, '')

FROM awc_register

WHERE DATEDIFF(day, date_expiry, GETDATE())='3'print @tolist

 set @tolist = substring(@tolist, 2, len(@tolist))

 and I passed this @tolist to another procedure which should send mails for email addresses present in @tolist variable.

Problem  is I need to send the mail to each email address separatley.( not bulkly)

 

Thanks,