hi sardinka,
Should be....
@Query = @Inactive

JFB

"sardinka" <sardinka2 (AT) yahoo (DOT) com> wrote

Should be like this?
Execute CDO_SendMail
@From = 'test (AT) msn (DOT) com',
@To= 'test1 (AT) msn (DOT) com',
@Cc = '',
@Bcc = '',
@Subject = 'Reports',
@MessageFormat = 0,
@Message = '' , @Query=@Inactive

I don't have @query parametrs.

Ok,
Well try to replace @message for @query
if doesnt work then use regular email utility from sql, more information you
can find in BOL.
JFB


CREATE PROCEDURE emailTest
AS
DECLARE @temp varchar(512), @emailSubject varchar(80)
SET @emailSubject = 'Counts for Test'
SET @temp = 'SELECT count(col001) as exp1
FROM test'
EXEC master.dbo.xp_sendmail 'email (AT) address (DOT) com',
@subject=@emailSubject,
@query=@temp
GO


"sardinka" <sardinka2 (AT) yahoo (DOT) com> wrote