Well I will start by saying that I am not familiar with coding in HTML. However, I do have a module that generates an XML document for me by writing to a text file and I would think you could do the same thing for an HTML output. You could use a DAO Recordset to gather the data you wish to export (you can use the same SQL statement your report is based on) and simply include the HTML code and the outputs in a series of TextFile.WriteLine commands. Below is a snippet of code that is basically what I use to generate my XML but I've swapped out my XML header for some basic HTML code to give you an idea of how you might format it.
Code:
Sub ExportXML()
Dim rst As DAO.Recordset, fs, TextFile, strSQL As String
Set fs = CreateObject("Scripting.FileSystemObject")
Set TextFile = fs.CreateTextFile(myPath & myFileName.xml")
strSQL = 'Your report SQL statement goes here
Set rst = CurrentDb.OpenRecordset(strSQL)
' Generating your HMTL code
TextFile.WriteLine("<!DOCTYPE html>")
TextFile.WriteLine("<html>")
TextFile.WriteLine("<body>")
Do Until rst.EOF
TextFile.WriteLine("<p> & rst![YourFields] & "</p>")
Loop
rst.Close
Set rst = Nothing
Hope this helps!
Windows 7 64bit 
Access 2010 64bit
Reply With Quote
