Thanks for the responses. I created a template spreadsheet and used SSIS to populate the values in separate sheets. Then used msdb.dbo.sp_send_dbmail to email the spreadsheet. A round about way,...

Instead of using a space or double qoutes, use TAB

@query_result_separator=''