Help with OutputTo and Word

  • Thread starter Thread starter Frederick Wilson
  • Start date Start date
F

Frederick Wilson

Hello all,

Can someone direct me to information on how to do the following.

I have a report which I have laid out exactly like I want it. It has
lines, formated fonts (bold, italics) and other items. Beautiful if I do
say so myself.

Little did I know that when I OutputTo Word it would drop all the
drawing stuff. Is there a way to keep this format together?

Some might be asking why. The data in the report is pasted into another
word document which is produced and distributed weekly.

Thanks,
Fred
 
Frederick Wilson said:
Hello all,

Can someone direct me to information on how to do the following.

I have a report which I have laid out exactly like I want it. It has lines,
formated fonts (bold, italics) and other items. Beautiful if I do say so
myself.

Little did I know that when I OutputTo Word it would drop all the drawing
stuff. Is there a way to keep this format together?

Some might be asking why. The data in the report is pasted into another word
document which is produced and distributed weekly.
Click to expand...

Output to Word has more problems that just dropping the graphics. In fact all
of the OutputTo formats drop graphical elements except for Snapshot Format. You
will often see extra line-breaks and truncation of data when using the RTF
option as well.

Alternatives...

* Snapshot Format
* Use third party software to create a PDF file
* Use Stephan Lebans utility that wraps the Snapshot output into an RTF file
* Use file i/o to write the RTF out to a file in a custom code routine.
* Mail-Merge to a word template file
* Code to automate Word after the OutputTo to fix any problems and add the
graphical stuff back in.
 
Thanks Rick.

I was kind of leaning to code the output straight to a word template but
this would entail me having to learn MS Word VBA, if I'm not mistaken.
Additionally, conceptionally I think in order for something like that to
work I would have to use a loop routine to get all the stuff in the
right place, this would/could take forever with some of the reports
being more than 30 pages long.

Any thoughts?
 
Frederick said:
Thanks Rick.

I was kind of leaning to code the output straight to a word template
but this would entail me having to learn MS Word VBA, if I'm not
mistaken. Additionally, conceptionally I think in order for something
like that to work I would have to use a loop routine to get all the
stuff in the right place, this would/could take forever with some of
the reports being more than 30 pages long.

Any thoughts?
Click to expand...

Sorry, I have never automated Word so I can't provide much guidance there.
 
Back
Top