Can DatabaseMail attach a formatted Excel file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Can DatabaseMail attach a formatted Excel...

Can DatabaseMail attach a formatted Excel file

Rate Topic

Display Mode

Topic Options

Author

Message

sandosh.star

Posted Tuesday, February 05, 2013 9:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 11:25 PM
Points: 3, Visits: 15

my query

USE [AP_ECC]
GO
/****** Object: StoredProcedure [dbo].[ap_ecc_Mail_for_statuslog] Script Date: 02/06/2013 11:03:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[ap_ecc_Mail_for_statuslog] as
EXEC 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 type

Post #1416224

SQLRNNR

Posted Tuesday, February 05, 2013 11:19 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858, Visits: 12,443

please don't cross post

http://www.sqlservercentral.com/Forums/Topic1416223-392-1.aspx

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1416253

« Prev Topic | Next Topic »

Permissions