xp_sendmail error

[cmmrfrds]

I am using xp_sendmail for the first time after getting Sql mail setup on my server. The mail works okay for alerts. I am using the xp_sendmail in a stored procedure.

The error is;
ODBC error 2812 (42000) Could not find stored procedure 'mail'.

Any idea of what could be going wrong.

Thank you,
Jerry

 

[fluteplr]

Post the code.

 

[cmmrfrds]

This is the SP, created in the master database.

alter Procedure sp_TestMail
As
declare @msgText varchar(255)
SELECT @msgText = 'This is my mail test'

exec xp_sendmail 'greatwhite', @msgText, 'mail test'

return

 

[tlbroadbent]

xp_sendmail is treating your subject as a Query and trying to execute the SP named 'mail'. Name the XP parameters as follows.

exec xp_sendmail
@recipients = 'greatwhite',
@message = @msgText,
@subject = 'mail test'
Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm