Automating Word with OutputTo or VBA

[paulmcdonnell]

Hi guys,

I starting to do a lo of exporting to word now. problem is i've forgotten how i did i before.

I can open a word doc and export items i need through code. but I kow that I can export full reports to word using

DoCmd.OutputTo acOutputReport, lettersource, acFormatRTF
but the acformatRTF is no good for me I'm sure that I've exported to .doc before but acformatmsword isn't the option.

Does anyone know how i do this.

It save a lot more time than doing the VBA for CreateObject("Word Application") etc etc.

-
To clarify : in one of my reports I have and OLE Class word200 embeded object full of text I need to export to word. RTF looses this.

-
Cheers
Paul

 

[Kraj]

If you find a way to do this let me know. I've grappled with this many a time. My ultimate solution was to create a mail merge template that used an Access query as the data source. It doesn't directly export the report, but instead creates it directly in Word. This is a pain but it works.

I also ran into problems when the source query referenced another query... Word wouldn't use it for the template. It's a start for you, at the least.

 

[paulmcdonnell]

Thanks

I am working on something at the moment that i can't get right but i'll post it if i do.

Paul