Thank you very much, Bret. This is almost exactly what I needed.

There is however one problem: How do I incorporate the WHERE condition to the report in this command? I can't see it from the command template:

Report Template:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

OutputTo Template:

DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][, autostart][, templatefile]

Thanks in advance
Charles Richard

>>Can anyone tell me how to programatically create a HTML report from an Access report? (I.E. Save as HTML does it through a wizard manually. I want to automate this)
>>
>>Thanks in advance
>>Charles
>
>DoCmd.OutputTo with the acFormatHTML parameter.