As far as CDO, you should take a look in the script library, might find something already made. If not, still not hard to write a wrapper around it that gives it the ability to return a recordset and loop through it to build up the message - or maybe just save as xml and combine with XSL to generate content.

Andy