>I have a submit form that access an SQL server and display the result in a HTML table. This submit form will have a checkbox that asks if you want to e-mail the report.
>What I would like to do on the fly is to save the report to a file in html format and then email it.
>The emailing part I have already done, but I do not know how to save the report as an html format. ( once saved on the harddisk I can attach it to the emails )
>
>Thanks,
>Sergio
Just build the HTML in code and use the FileSystemObject to save it to a file.
Make sure you come up with a unique name, you don't want user B overwrite the user A file. Be sure you clean up those files because you may end up with lot's of them.