Question

sanjay devaraj on Thu, 07 Feb 2013 03:49:52


Hi,

How to send table data as attachment in excel format from Stored procedure to predefined mail id.


Sponsored



Replies

RohitGarg on Thu, 21 Feb 2013 19:30:58


YOu can use sp_makewebtask system store procedure or bcp out or SSIS to genrate Excel file.

After that you can  parameter    @file_attachments  of sp_send_dbmail store procedure to send excel with mail alert