newbie to xml

[tman24m]

I'm new to xml and i'm looking for a way to output 100+ email letters in html using xml and xsl. the body of the data needs to come from a letters table in sql and the recipients would come from a different table. i have no idea what to do, can i get help?

thanks

 

[jel]

If you're using SQL2000: check the documentation on xml-output, it's really simple to generate xml.
If not: you could programmaticly generate xml by ADODB, using the Save method. (argument adPersistXML)
You can save directly into a dom-document, and transform with a stylesheet you loaded in another DOMdoc.