InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 08:48:23 GMT20http://www.sqlservercentral.com/Forums/Topic1416223-392-1.aspx[quote][b]foxxo (2/6/2013)[/b][hr]You need a tab delimited file for excel to recognise it and the file extension needs to be .csv (.xls will work but will display an error first).eg.[code="sql"]DECLARE @query_result_separator CHAR(1) = char(9);EXEC msdb.dbo.sp_send_dbmail@recipients=N'test@test.com',@body='Hi Team,Please find attached the status log for today.Please check the status .Regards,Reporting team',@subject ='Status Log for Today'--,@profile_name ='Status HDS A',@query ='SELECT ''dddddddddd'' as columnheader, ''aaaaa'' as col2, ''ffffff'' as col3UNION ALL SELECT ''a'',''b'',''c''',@attach_query_result_as_file = 1,@query_attachment_filename ='Status_Log.csv' ,@query_result_separator= @query_result_separator,@exclude_query_output = 1[/code][/quote]Please do not make a tab delimited Comma Separated Value file (what csv stands for). Now the suggestion to create a type of file excel can open and display with out being an xls(x) is a very good one. my personal preference is a tab delimited text file (using .txt) or a pipe delimited file as both tabs and pipes are rarely present in data (unlike commas which in a csv file need special handling).Wed, 06 Feb 2013 11:31:12 GMTCapnHectorhttp://www.sqlservercentral.com/Forums/Topic1416223-392-1.aspxYou need a tab delimited file for excel to recognise it and the file extension needs to be .csv (.xls will work but will display an error first).eg.[code="sql"]DECLARE @query_result_separator CHAR(1) = char(9);EXEC msdb.dbo.sp_send_dbmail@recipients=N'test@test.com',@body='Hi Team,Please find attached the status log for today.Please check the status .Regards,Reporting team',@subject ='Status Log for Today'--,@profile_name ='Status HDS A',@query ='SELECT ''dddddddddd'' as columnheader, ''aaaaa'' as col2, ''ffffff'' as col3UNION ALL SELECT ''a'',''b'',''c''',@attach_query_result_as_file = 1,@query_attachment_filename ='Status_Log.csv' ,@query_result_separator= @query_result_separator,@exclude_query_output = 1[/code]Wed, 06 Feb 2013 00:21:00 GMTfoxxohttp://www.sqlservercentral.com/Forums/Topic1416223-392-1.aspxmy queryUSE [AP_ECC]GO/****** Object: StoredProcedure [dbo].[ap_ecc_Mail_for_statuslog] Script Date: 02/06/2013 11:03:01 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[ap_ecc_Mail_for_statuslog] asEXEC msdb.dbo.sp_send_dbmail@recipients=N'internal@zeroone.com',@body='Hi Team, Please find attached the status log for today.Please check the status .Regards,Reporting team',@subject ='Status Log for Today',@profile_name ='Status HDS A',@query ='SELECT [TableName] ,[DateLastRun] ,[StartTimeStamp] ,[EndTimeStamp] ,[StatusLastRun] FROM [ICMRPTSVR].[ICMRPTDB].[dbo].[icmrptdb_statuslog]',@attach_query_result_as_file = 1,@query_attachment_filename ='Status_Log.txt' my query is attaching txt file i want it as excel typeTue, 05 Feb 2013 21:22:41 GMTsandosh.star