You can use sp_send_dbmail for that
see
http://technet.microsoft.com/en-us/library/ms190307.aspx
you would need a logic to get emails in a dlimited format as below
DECLARE @EMailList varchar(max)
SET @EmailList=STUFF((SELECT ';' + Email
FROM Linkedservername.dbname.dbo.tablename
....any conditions here
),1,1,'')
Then pass @EMailList to parameter
@recipients
of sp_send_dbmail procedure.
I hope subject of the mail would be static otherwise you need a loop to create subject for each user and then sent the mail.
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs