This is probably old news to many people, but sometimes I'm a slow learner.
So far, getting neat, color-coded code from Management Studio or Visual Studio into passable Blog-ready HTML has ... well ... mostly made me go, "Aaarrrrrggghh grrrr @*%$^#&! grrrr aaarrrgg <repeat>." I've tried several online code prettifiers, and even Word (yech) but it's painful to take code from one tool, paste it into a formatter, format it, take source out again, correct it with elaborate regex find/replace, repeat. Redgate has a nice tool for T-SQL code formatting inside Management Studio, but it doesn't, in my version at least, help with the HTML bit at all.
I know many people are very, very careful to meticulously hand format their code, and while I completely appreciate the desire for neat code and try to write neatly myself, I can't quite stomach all the extra hours spent pressing the spacebar, when a tool could do a very nice job. In C# I'm the first to admit I am completely spoiled by Ctrl+K Ctrl+D. High formatting value from minimum biological effort.
After my last post, which was long on code and very frustrating to format, I am onto this tool: http://copysourceashtml.codeplex.com/ which looks more like it. Visual Studio > Highlight > Copy > HTML Editor or Browser > Paste > Aah. What computers are supposed to do.
We'll see if this lessens my pain on the next post.
[Edit 4/23/2010]
I took ALL the commenters' advice to heart, and after spending way too much money I have a great solution: I got a MacBook Pro (Aaron) plus vmware Fusion and Windows 7 back in January. Then I was able to start using Windows Live Writer (Adam), and add the vspaste plug-in (Dave). Lastly, Red Gate SQL Prompt Pro has a really nice pretefier that works inside SSMS, and while it doesn't make HTML directly it does neatly format the code. I can finally write something sloppy, then go Ctrl-K Ctrl-Y Ctrl-A Ctrl-C <click Live Writer> Paste, Post. Sweet!