I have created a report which displays the number of objections and type of objections that a planning application has received. What I would like to do is when I enter the planning application ID on the form it opens up microsoft word with the data in it, just like the below report. The reason why I need the report to open in microsoft word is that I need to copy and paste all the information into an application. I think you can do this using macros but I'm not sure.
The report has been created using 3 sub reports
1 subreport to get the number of objections
1 subreport to get the coded list objections (Density too high, Loss of trees)
1 subreport to get the additional comments (Inadequate open space provision, Gardens too small)
After I enter the application ID in the above image it creates a report and displays the below information. I would like the below information displayed in word.
Any suggestions would be appreciated.