Outputto using a Word template or track changes

[radder33]

Hello

I am writing a database that will export a report to MS Word for the user to make any necessary changes. Due to the nature of the report this is a necessary step (long story.)

I can get the report to export but ideally I would like to export to a template as we would like track changes to be switched on automatically.

I have tried outputting to RTF and running a macro through Word VBA on open but the macro doesn't get on with RTF. Any thoughts would be much appreciated at the moment my docmd does this
DoCmd.OutputTo acOutputReport, "SpecTextIncl", acFormatRTF, , True

 

[Andrzejek]

If you already have a template created in Word, I would place Bookmarks in the template where my data from Access should be placed.

In your VBA in Access you may call Word (early binding good for writing code, late binding better for run), open the template, call (Go To) each bookamark and place the info from Access where your bookmark is.

Have fun.

---- Andy

 

[radder33]

The report can have multiple selections though depending on what the user does in the form so wouldn't this throw out the formatting etc depending on the selections?

I have at present 200+ possible selections to make up the report would this mean 200+ bookmarks?

 

[Andrzejek]

That all depends on how complicated your Word report would be.

I create some letters in Word based on templates where some data comes from the data base, so template has some bookmarks that I fill with data.

I also do a lot of reporting in Excel, that's another option.

Your case may need just 'regular' report in Access. it all depends what you want to have in your report and how your users will use it.

Have fun.

---- Andy