halifaxdal (8/30/2012)
To make things simpler, I feel this would be easier:1. Instead of creating a fancy report, just create a stored procedure to generate a spreadsheet and use it as attachment, send it out to recipients.
That would be fine except you cannot create a spreadsheet using Database Mail. You can create a csv file and name the file with a xls extension but that really not the same thing at all. You will not be afforded any ability to format the display when it opens in Excel and in some newer versions of Excel (2010 at least) a popup will be displayed when the file is opened letting the user know that the file format is inconsistent with what is expected from a file with the xls extension.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato