convert a report to HTML using a template

[danial.a]

Hello all,
i have a report with report header and page header and detail sections.i want to convert it to HTML in order to publish it via email.
i use DoCmd.OutputTo acOutputReport, "Report1", acFormatHTML, "C:\Users\Danial\Desktop\report1.HTML", False, , UTF - 8 and it's converted.
but none of original report format such as borders around textboxes and labels are shown in HTML file.also HTML file is disordered and texts shown
in incorrect positions and have not good view.i want to HTML file have good view and format such as border and background color.
i tried to format it with a template HTML file using HTML tags but none of them took affected in converted HTML file and result is same as before.
i googled a lot to find HTML templates to use for convert access report but found nothing!
any help is highly appreciated!

[ranman256]

just send it via 1 statement:
DoCmd.SendObject acSendReport, "rptMyRpt", acFormatPDF, sTo, , , sSubj, sMsg
or
DoCmd.SendObject acSendReport, "rptMyRpt", acFormatHTML, sTo, , , sSubj, sMsg

[ItsMe]

I have always created an HTML file using editors like DreamWeaver or FrontPage. I would then translate that code into VBA. With the HTML translated, you can insert it onto the body of your email while automating Outlook. The trick is to concatenate variables with the HTML.

Otherwise, you will always have difficulties with Access Controls, Lines, etc not getting translated during the export process.