I'm using this in a step within a job. So when I use the varchar why is it I can't get the length to 7999?

Now I get: Could not find stored procedure 'master.dbo.xp_sendmail'. [SQLSTATE 42000] (Error 2812). The step failed.

Well I did the suggestions but now it just hangs on Performing Completion Actions. This is what I'm putting in the command field:

exec master.dbo.xp_sendmail @recipients = 'Muscarello Roger',

@subject =...

I've setup SQL Mail and also setup SQL Server Agent to use email. That's what I thought I was supposed to do. I created a new job. ...