Need to have the contents of an Access report end up in MS Word Doc

[DPROMICS]

I need to have the contents of an Access report end up in a MS Word Doc.

I have a medical practice Access App and database. There are several patient/clinic visit reports in the app.

I need to some how, easily, have the contents of a report end up in a Word doc. The Word doc would then be saved in such a way that it can be accessed by patient name by the clinical and support staff. The transcribed reports and letters are already accessible via a sort of non-DB method. That works quite nicely for the staff. Sort of a patient letters / reports "database". Nope, not an Access or other database app. L o n g story. But it works.

Anyway, it will be the transcriptionist or other support staff that runs the report and "causes" its contents to end up in a Word doc file or Word opens with the report information in it. The later is the prefered method.

Either way it must be simple and painless for the transcriptionist and/or support staff. Hopefully, it is something that can be accomplished from Access rather than having to add another (intermediary) program to do it.

I have searched the Tek-Tip Access threads for anything like this and didn't find any "solutions" that meet my specific needs.

OK, how can I do this the way I would like to have it work?

Best Regards,

 

[JoeAtWork]

Well, if you open the report in preview mode, you could use the "Office Links" button to "Publish it With Microsoft Word".

However, the more complex the format of the report is, the more likely it will be messed up in Word. But it works pretty well for simple reports.

 

[DPROMICS]

Thanks. I'll have to try that when I have a momentand provide some feed back on this post as to how well it worked out.

I appreciate the help.

Best Regards.

 

[formerTexan]

Consider saving the reports in .rtf format. They can then be viewed by anyone with one of the later versions of Word.

RTF generally does a good job of maintaining the report's appearance and you don't have to deal with messy Office links.

Memory is a bit hazy, but I believe you can right click on an open report, select export and then select the format.

Cheers,
Bill

 

[Lilliabeth]

Forgive me if I am missing something, but aren't

"use the Office Links button to Publish it With Microsoft Word"

and

"saving the reports in .rtf format"

exactly the same?

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[DPROMICS]

use the Office Links button to Publish it With Microsoft Word" Yep, does work . . . except.

1) Microsoft in their attempt to . . . unless one clicks on the "expand" part of any drop down menu one doesn't see all of the options. I didn't see the "Use Office Links . . ."

2) The "Use Office Links and publish to Word" works great. Except for one minor detail. Any pictures on the report don't end up in Word. I have a JPG in a box as part of the practice's logo. It doesn't get carried over to the Word document. The plan is to have the practice's logo/name, address, docs, etc. report header be a JPG that gets inserted from a table, s this is going to be a problem. Unless anyone knows a way around it.

Although, if one were to setup the "default" (Normal.dot) file with a practice's logo/header text already setup as the header on a new document then this wouldn't be a problem. Hmmm . . .

Thanks all for the suggestions and help.

Best Regards,