I just figured out what my issue was. And as usual, it was something I was doing wrong. Albeit it's odd it works this way.

I was assigning several values to a @BodyText variable. Building a body message really. Then sending that @BodyText to the @Body for the sql server email.

The kicker here is that if any of the values are null, or blank (??), it nulls out the whole @BodyText variable & sends nothing at all. You'd think, logically, that if a value was blank or null, it would put that in that section & just send a blank value.

Here's my example:

Set @BodyText = 'Mirroring Status Alert!!!' + CHAR(13) + CHAR(13) +

'Date:' + @DateTime + CHAR(13) +

'Server:' + @@ServerName + CHAR(13) +

'Database:' + UPPER(@DatabaseName) + CHAR(13) +

'Mirror Status:' + CAST(@MirrorStatus AS VARCHAR(1)) + ' - ' + @MirrorStatusDescription + CHAR(13) + 'Unsent Log size:' + @UnsentLogStatus

So if @MirrorStatusDescription or @UnsentLogStatus somehow ended up blank, the whole @BodyText was blank. That's just plain silly.

Anyways...I fixed it. I'm not sure why others were experiencing it unfortunately.