Of course.  I do this w/several jobs -- use DTS, a transform data task from server to csv file.  The transform source is your procedure, the destination is the csv file, the transformation is just a 1 to 1 of your proceduer resultset -- i.e., you procedure returns Date,User,Volume -- that's your transformation.

then you've got a sql agent job, 1st step invokes the DTS pkg, like this:
exec master..xp_cmdshell 'DTSRUN /S "servername" /E 'N "packagename" '

the 2nd step in your job is the email.  i do mine like this:

EXEC master..xp_sendmail @recipients ='whomeverYourSendingItto@wherever.com',
@blind_copy_recipients = 'maybeYourself@wherever.com',
@attachments = '\\servername\h$\filename.csv',
@subject='subject line for the email',
@message='any message you'd like to send along with the attachment'

no worries.  as i said, i'm running a lot of these.  let me know if you need any further info

oh yes, i'm sorry, i should have given more detail.  i use smtp and my own version of xp_sendmail.  see here:

/****** Object:  Stored Procedure dbo.xp_sendmail    Script Date: 10/18/2006 9:25:17 AM ******/
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/****** Object:  Stored Procedure dbo.xp_sendmail    Script Date: 10/18/2006 9:25:17 AM ******/
-- create replacement xp_sendmail procedure
CREATE proc dbo.xp_sendmail
@recipients                   varchar(8000) = NULL,
@message                   varchar(8000) = NULL,
@query                   varchar(8000) = NULL,      -- parameter will not be used
@attachments             varchar(8000) = NULL,
@copy_recipients            varchar(8000) = NULL,
@blind_copy_recipients            varchar(8000) = NULL,
@subject                   varchar(8000) = 'SQL Server Message',
@type                   varchar(8000) = NULL,
@attach_results             varchar(8000) = NULL,      -- parameter will not be used
@no_output                   varchar(8000) = 'FALSE',-- parameter will not be used
@no_header             varchar(8000) = 'FALSE',-- parameter will not be used
@width                   int = 80,            -- parameter will not be used
@separator                   varchar(8000) = NULL,      -- parameter will not be used
@echo_error             varchar(8000) = NULL,      -- parameter will not be used
@set_user                   varchar(8000) = NULL,      -- parameter will not be used
@dbuse                   varchar(8000) = NULL      -- parameter will not be used
as
set nocount on

declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
      @FROM                  = N'YOURSERVERNAME',   -- change value to suit your own needs
      @FROM_NAME    = N'YOURSERVERNAME',   -- change value to suit your own needs
      @TO                     = @recipients,
      @replyto                  = 'YOURNAME@WHEREVER.COM',       -- change value to suit your needs
      @CC                    = @copy_recipients,
      @BCC             = @blind_copy_recipients,
      @priority                = N'normal',      -- change value to suit your own needs
      @subject           = @subject,
      @message           = @message,        -- no equivalent parameter value available
      @type           = N'text/plain',      -- change value to suit your own needs
      @attachments   = @attachments,      
--      @attach_results  = @attach_results,
      @server       = N'YOURMAILSERVER.COM',  -- change value to suit, like mail.domain.com
      @timeout       = 10000                     -- change value to suit your own needs

if (@@error <> 0 or @rc <> 0)
      raiserror(N'Sending message using xp_sendmail failed', 16, 1)

return @rc
set nocount off

GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

No problem at all, alexish.  I totally know what you mean.  Let me know how it goes.