OutputTo option for HTML file

rry2k · May 31st, 2004, 02:50 PM

Hi,

I am trying to send records from a table to an html file. I am trying
to use DoCmd.OutputTo acOutputTable, table1, acFormat.HTML, "c:\template2.html", , "c:\template.html"

but I get an error message that says: object required. I am sure what I'm doing wrong. Any help would be greatly appreciated.

Thanks..Russ

Steven · May 31st, 2004, 10:07 PM

put quotes around the object name, i.e.:

Code:

DoCmd.OutputTo acOutputTable, "table1", acFormat.HTML, "c:\template2.html", , "c:\template.html"

Steven

I am a loud man with a very large hat. This means I am in charge

Steven · May 31st, 2004, 10:08 PM

oops - there was a typo in that, due to me copying and pasting. Use

Code:

acFormatHTML

rather than

Code:

acFormat.HTML

I am a loud man with a very large hat. This means I am in charge