Andy and Steve!
Guys thankx for your input. I've given CDONTS already a shot, simply can't use it cause it can't execute queries on the fly. So, I either hunt down a product that can execute queries like xp_sendmail, or, figure out a way to make the profile switching work. Hey one of you guys mentioned profiles on the "active" server. I created an outlook profile only on one "node" of the cluster not on BOTH nodes. Are you suggesting create the same profile on both nodes and then try it.
-Also guys, I noticed when I issue a xp_stopmail @user ='blah' followed by a WAITFOR DELAY 15 seconds on node1, the cluster server actually kick-starts sqlmail using the profile I >>>dont want<<<. Is this something that is possible?