Using a select statement as body of email

• Bob Bridges-173967

  SSCrazy

  Points: 2094

  More actions

  August 30, 2006 at 8:44 pm

  #169535

  I am using the sp_send_cdosysmail stored procedure.  The following works fine sending an excel spreadsheet (or more accurately, a link to an excel spreadsheet.)

  But is it possible to put a select statement as the variable @WO? For instance, I would like to send the results of "Select UserLogin, Deptid from tblUser where UserLogin = 'bbridges' "

  Is this possible?

   

  DECLARE @WOs varchar(4000)

  select @WOs = '\\e000472\C$\MailTest.xls'

  EXEC AccurideUtilities.dbo.sp_send_cdosysmail

  'ACCCORPSQ01', -- the "From" in the email

  'me@here.com', -- the "To" in the email

  'Global Database Update Failed', --The "Subject" in the email

  @WOs --The body of the email message

   

  Thanks very much.

  Bob

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  August 31, 2006 at 12:30 am

  #657730

  Do you want to send select statement or resultset it returns?

  _____________
  Code for TallyGenerator

• Bob Bridges-173967

  SSCrazy

  Points: 2094

  More actions

  August 31, 2006 at 4:25 am

  #657760

  I want to send the result set that it returns.