Read this blog
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104042[
^]
Solution as per blog
DECLARE @Receipientlist varchar(8000)
SET @ReceipientList = STUFF((SELECT ';' + emailaddress FROM Your query here FOR XML PATH('')),1,1,'')
EXEC sp_send_dbmail @profile_name= your email profile in db,
@recipients=@Receipientlist,
@subject='your subject here',
@body='body message here'
...