We actually use something called sp_send_cdosysmail. We found it on this site and it works well for us. I also found it on Microsoft's website, so I don't know who is the original author. I think it might only send text email though.

I can't speak to other people's experiences, but from my own, using CDO from this procedure has worked well for me.