Report output to Word Document, not RTF

[Guest]

Hi,

Sorry to ask what is probably a simple things, but being a newbie with this
I have no idea if it can be done.

I know how to output the report to Word rft format, but I like to know if I
can do it to Word .doc instead.

I have on report that shows up in a tabled format in Access, but when it
goes to Word .rtf, I loose all the lines and can't set it up in tables in
word.

Is there a way to use a macro or vb some how to output the report into Word
..doc in table format?

The report gathers data from about 20 fields, at the moment I have to copy
and paste each part into the Word .doc tables that the Access report mimics.
Any suggestions would be appreciated, especially if its explain in a way that
a newbie could understand it. Thanks to anyone willing to look and respond
to this.

 

[krissco]

Hi,

Sorry to ask what is probably a simple things, but being a newbie with this
I have no idea if it can be done.

I know how to output the report to Word rft format, but I like to know if I
can do it to Word .doc instead.

I have on report that shows up in a tabled format in Access, but when it
goes to Word .rtf, I loose all the lines and can't set it up in tables in
word.

Is there a way to use a macro or vb some how to output the report into Word
.doc in table format?

The report gathers data from about 20 fields, at the moment I have to copy
and paste each part into the Word .doc tables that the Access report mimics.
Any suggestions would be appreciated, especially if its explain in a way that
a newbie could understand it. Thanks to anyone willing to look and respond
to this.

Your report is like a table? Why not export the query your report is
based on instead of the report itself. When you export a query to rtf
it shows up as a table.

DoCmd.OutputTo acOutputQuery, "yourQueryName", acFormatRTF, , True


This will probably create a really ugly document. . . but that's kind
of the risk of using DoCmd.OutputTo (the ugliness).


If you need your finished product to be a .doc and not a .rtf, or you
really want to invest the effort to make your .doc file look pretty
then use Word Automation. You can (through code) build pretty much
anything any way you want it to look in Word.


-Kris

 

[Guest]

Hi Krissco,

Thank you for your suggestions. I will look it up and see if I can do this.