Make a report the same as form and sub using mail merge

[Elmobram22]

Hi,

Just wondering if this is possible. I am using mail merge to add info from my database to my word document template. I want to make it the same as my form I have set up which gives me a patient name, dob, GP details as head of main form then a subform (continuous) of their medication. When I try a mail merge it comes up right but only shows one medication on each page. I want it to add all their medications to the body and have the patient info in the heading. Do-able?

Cheers

 

[Elmobram22]

I think report would be fine if I can make it look the same as my word document template which I should be able to do. What kind of VBA code do I need or is there somewhere I can read up on how to do this?