Help using xp_smtp_sendmail

[Howard7890]

I am trying to develop email functionaliity.

I tryed creating this sproc:

CREATE PROCEDURE sp_STML AS
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM_NAME = 'Howard Kline',

@TO = '[email protected]',

@subject = 'Hello SQL Server SMTP Mail',

@server = 'caexmta5.amd.com'

select RC = @rc
GO

I get rc = 1 when I execute this.
What am I doing wring

Any ideas?
Thanks.

[abhijit]

Hi Howard,
Have you got MSExchange setup? There are a lot of configuration issues involved. You need to have the propert permissions from your mail server to enable you to send mail.

Only then will you be able to use the stored proc to send mail. Most SMTP mail Servers check if the user is actually logged in.

Cheers!
Abhijit