I'm late to the party but I do send scheduled emails with HTML formatting using SSIS.

It's a bit involved since I need to use XML to create the table and then wrap the HTML formatting around that then a script task to send it but it works great. Now.

I'm sending basic tables but if you want to plunk around to make fancy stuff I can post the steps that work for me.