Exporting A Report into Word

[vand_uk]

I have a report that shows all the details I need to send to other clients. I can print it out fine. Although I have large blocks of text that I copied and pasted from a word file into it, to save me having to type it all out. But when I try exporting to a Word file It doesnt show the blocks of txt, it only shows up with the fields thats on the report! Is there a way I can get around this??

Thanks

 

[The_Doc_Man]

The good news is that you can do some things to send data from Access to Word. The bad news is that Access reports don't export well - they lose all formatting because Access isn't a word-processing program.

The best way to have template text (or what some companies call boiler plate) plus some specifics is to do a mail-merge to Word. Make your output fields that have all the text into fields. Anything that is a constant becomes part of the merge template file. This preserves formatting for you.

There is another way using VBA and Automation, but I'd look into MailMerge first. The automation is ugly 'cause Word is ugly at the Component Object Model level, and that's where you would be working.

 

[Bat17]

Depending on the use of the report, you may want to look at saving it as a snapshot or PDF file.

Peter