Hello,


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)


Form



Report

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.

Thanks

Hi,
you should be able to output the report to the rtf format using the OutputTo() method. If you set the last boolean 'AutoStart' argument to true it automatically opens up in word after the output is done.
HTH
Good luck