Outputting a Report to HTML - Eliminating Page Breaks and Other Formatting Woes

[Dr. Know]

Greetings,

I am writing an overdue account E-Mail program that uses CDOSYS to
E-Mail an overdue notification report created with the DoCmd.OutputTo
method and an HTML template file. Everything works until I get to
accounts that have over 34 past due invoices in the detail. (This is
an arbitrary number based on the available space on the page.)

After this point Access insists on paginating the output into multiple
HTML files. We don't want this behavior, and want ALL detail to
appear in the body of ONE HTML document.

Also, when exporting, ACCESS insists on removing all formatting other
than text boxes - horizontal rules, background colors are all removed.

Does anyone know how to eliminate these behaviors?

Or do I have to code up my own HTML Template Merge parsing routine to
accomplish this? This was my first instinct, but time considerations
caused my to attempt the 'out of the box' solution.

Thanks,
Greg


Dr. Know

 

[Dr. Know]

Dr. Know said:

Greetings,

I am writing an overdue account E-Mail program that uses CDOSYS to
E-Mail an overdue notification report created with the DoCmd.OutputTo
method and an HTML template file. Everything works until I get to
accounts that have over 34 past due invoices in the detail. (This is
an arbitrary number based on the available space on the page.)

After this point Access insists on paginating the output into multiple
HTML files. We don't want this behavior, and want ALL detail to
appear in the body of ONE HTML document.

Also, when exporting, ACCESS insists on removing all formatting other
than text boxes - horizontal rules, background colors are all removed.

Does anyone know how to eliminate these behaviors?

Or do I have to code up my own HTML Template Merge parsing routine to
accomplish this? This was my first instinct, but time considerations
caused my to attempt the 'out of the box' solution.

Thanks,
Greg

Anyone? Or are both of these behaviors impossible to modify?
TIA





Dr. Know