acces - Word

[Jean-Paul De WInter]

Can I automatically copy data from an access query into a word document
instead of using a report??
Thanks
JP

 

[Mark Phillipson]

Hi,

You can output a report as a Rich text file (*rtf) which word can read.

For example:

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

Note the last argument if True will launch what every application is
registered to open with Rtf files. This is Word by default on my machine.


--
HTH

Mark Phillipson

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