Challenge Accepted.

Looks like ole objects and a few other things don't get exported into word so you'd have to use a PDF for those. What formatting are you trying to keep?

Why are you wanting it in Word?
Does it need to be further filled in?

My director needs the information generated from my report added to a confidential narrative he adds.
Cutting and pasting from pdf looses the formatting as well.

Can I expect my report as an image perhaps?

If nothing else you just snip tool your report and paste it into word :P

Is this all just text?

Just table of figures

Is there a way to automate the Snip Tool from within Access?

Probably not without using sendkeys which I don't know if I'd do.

What happens when you use the built-in export to word? Takes the boxes out?

If you decide to go down the sendkeys path, it's probably easier to full screen the report and sendkeys print screen instead of trying to snip

Yes, the boxes disappear.

I wonder if I can create the Word document and then Mail Merge my data automatically, is that possible?

One way is export both your Access report and Word doc to PDFs and combine them into one PDF to show your boss.  You can combine PDFs with a third-party tool like PDFtk, which has a command-line tool that Access VBA can use to automate the task.

Kevin
Manually I can do this without any problems. I am trying to completely automate this. So my boss clicks on a button and out comes the Word document.

You can definitely automate all 3 steps:

- Export Access report to PDF with DoCmd.OutputTo.
- Export Word doc to PDF with Document.ExportAsFixedFormat: https://learn.microsoft.com/en-us/office/vba/api/word.document.exportasfixedformat
- Combine two PDFs with PDFtk command line, with Shell() command in VBA

Thank you Kevin
I will give it a try later in the week when I go back to work.

Legacy Tip: Screenshot using VBA

Alex thank you
I will also try this. I shall report back.

Sami have to concidered merge?  have the information in Access and have Word extract it?

Hi Juan.
Yes I actually said that above. I looked at my report and it does not have too many fields.
On Friday and the weekend, I am going to try the suggestion I got from my friends here.

Apologies, I've attempted something similar using Access and Word myself. I tried exporting a report with a header and footer, along with a styled heading, to make a master document with a table of contents (no luck). Perhaps someday I'll be skilled enough to accomplish tasks like this. LOL

You could do most of the work in the Word document as far as the formatting in the boxes and stuff goes, and then just pull in your data using either actual mail merge or just custom codes that you make yourself. You can open the document from VBA and then fill in the blanks. That's kind of what I do with the handbook generator. I've got a blank Access handbook Word document with some custom fields in it like {TITLE} and {TOC}, and then I have Access open up that document and fill in all the information so you'll keep all your formatting. I'm happy to share the code with you if you'd like it.

Yes please Richard. I would love that.
I am also thinking this will make a great TechHelp video.

Thank you guys you all have been very helpful.

The Big Boss came up with the perfect and simplest solution.

Open the PDF file (created from Access with full formatting) from inside Word.

As Rick would say: Boom!

Word document that looks exactly like the original report: formatting, lines and all.

Thank you @Rick

De nada. Video coming up... :)