I am looking for something similar, here's the closest i've found.

http://www.sqlteam.com/article/sqlmail-in-depth

yes, it is possible, and built-in with something called SQL Mail (as opposed to "database mail").

i havent been...