Exporting an access database to HTML or Word docs

[Guest]

I have an Acces db that I want to export to HTML and Word.

In Word the mailmerge works well but I would like to see if I can automate
the process so that the db is exported and saved in Word by record rather
than a huge catalog. Any ideas?

Also want to export to HTML in the simplest manner without too much techie
input. Any help very welcome.

Many thanks,

David

 

[Mark Phillipson]

Hi,

First place I would start is the Docmd.OutputTo Method

i.e.

For Rtf (Word can read this)

DoCmd.OutputTo acOutputReport, "rptTest", acFormatRTF,
"C:\Test.rtf", True

For HTML:

DoCmd.OutputTo acOutputTable, "tblTest", acFormatHTML, "C:\test.html",
True


--
HTH

Mark Phillipson

Free Add-Ins at; http://mphillipson.users.btopenworld.com/