sql mail error

[timc]

I have a sql 2005 box that a programmer is trying to get a stored proc to send email. I can send emails with the sqlexec (job fails notify sent) and that works. However their code below fails with the error on the bottom. Any ideas?

SET @SUBJECT='Test Subject'
SET @BODY='Test Body'
SET @EMAILADDRESS='awehring@cmsstl.com'
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'sqlexec@cmsstl.com',
@recipients = @EMAILADDRESS,
@body_format = 'HTML',
@body = @BODY,
@subject = @SUBJECT;


Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42
profile name is not valid

[rmiao]

How did you set db mail on the server?