John Waclawski (3/11/2013)
I too am running into this with SQL Server 2008 R2 at the moment.I'm getting a subject line, no body text. Still plugging away at it. If I get it running, I'll post what I did to get it running.
Until then, if anyone has a fix, please elaborate.
Thanks!
Here is a piece of code i use for sending mail in SQL Server 2008 R2:
EXEC msdb.dbo.SP_SEND_DBMAIL @PROFILE_NAME = 'Your Profile Here',
@Recipients ='test@email.com',
@Subject = 'Subject Line',
@body = 'Your Message Here'
This article gives you step by step to setup db mail if you have not done so already: