send email with attachment using sql but excel has first row as -----

Sonali Avhad

I used following code

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sonali Avhad5y ago
By using your code i got csv file with first row as ---- value in each column.Please help me.I don't want that ---- value in first row.
0
Sachin Singh5y ago
use this SP
declare @qry varchar(8000)
declare @column1name varchar(50)
-- Create the column name with the instrucation in a variable
SET @Column1Name = '[sep=,' + CHAR(13) + CHAR(10) + 'customerid]'

-- Create the query, concatenating the column name as an alias
select @qry='set nocount on;select customerid ' + @column1name +
             ' ,companyname, contactname, country from customers'

-- Send the e-mail with the query results in attach
exec msdb.dbo.sp_send_dbmail @recipients="Your email",
@query=@qry,
@subject='Client list',
@attach_query_result_as_file = 1,
@query_attachment_filename = 'result.csv',
@query_result_separator=',',@query_result_width =32767,
@query_result_no_padding=1
0