InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 12:45:58 GMT20http://www.sqlservercentral.com/Forums/Topic639119-149-1.aspxHi,I have three different queries and should get populated to three different excel sheets in the same excel work book... i was able to send 3 queries result to single excel sheet using sp_send_dbmail code:EXEC msdb.dbo.sp_send_dbmail @profile_name = 'PMDBOSW', @recipients = 'nswetha03@gmail.com', @query ='set nocount on; exec dbo.SEND_THIS_MAIL; set nocount off;', @subject = 'Work Order Count', @attach_query_result_as_file = 1, @query_attachment_filename ='D:\SWETHA.XLS' ; SEND_THIS_MAIL is a proc which returns the multi query result set.let me know the procedure if it can be done......Mon, 19 Jan 2009 00:52:30 GMTnswetha03