exec msdb.dbo.sp_send_dbmail
@profile_name='ProfileName',
@body='Hello.',
@recipients='RecipientEmail',
@subject='Testing Email ',
@attach_query_result_as_file=1,
@query = @sqlQuery,
@query_attachment_filename='File.xls',
@query_result_separator=@tab,
@query_result_no_padding=1,
@query_result_header = 1,
@query_result_width = 32767
The email is sent with excel file.But Excel file has first row as ----- value in each column.
Please help me.