Hi,
you can create a view that represents the data like you need it, and then write the table to html-file on disk via an Web-Task in SQl-Server agent.
Or you can write the data including html tags in a global temporary table and bcp it out to file.
regards karl