 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / June 2005Help with OutputTo and Word
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 > Hello all, > [quoted text clipped - 9 lines] > Some might be asking why. The data in the report is pasted into another word > document which is produced and distributed weekly. 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.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com 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? >>Hello all, >> [quoted text clipped - 24 lines] > * Code to automate Word after the OutputTo to fix any problems and add the > graphical stuff back in. > Thanks Rick. > [quoted text clipped - 6 lines] > > Any thoughts? Sorry, I have never automated Word so I can't provide much guidance there. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.