I have never gotten sendmail to work with a query.  I am assuming there is a security issue that I'm missing, but it seems like I tried everything.

I had given...

I have tried lots of different combinations of code, but here is a simple example that I can't even get to work:

I run this from Query Analyzer:

EXEC xp_sendmail 'nkelly@...',...