• For one-off stuff I do for myself, I cheat and use sp_Send_DBMail to create a tab delimited file named like it is an Excel spreadsheet.

    DECLARE @Delimiter Char(1)

    SET @Delimiter = CHAR(9)

    EXEC MSDB.dbo.sp_Send_DBMail

    @Recipients='My.Email.Address@company.com',

    @Subject='Some Audit',

    @Body='Attached is some audit information.',

    @Query='SELECT Left(Name, 50) AS Name, Left(Description, 50) AS Description FROM MSDB.dbo.SysJobs',

    @Attach_Query_Result_As_File = 1,

    @Query_Result_Header = 1,

    @Query_Attachment_Filename = 'Audit.xls',

    @Query_Result_Separator = @Delimiter