Mailmerge with Word but not data not live

[smilla]

I'm trying to find a way whereas a user can click on a hyperlink on a webpage (intranet) and it opens a report with live data taken from Access.

My idea was to create a word template linking the data source to the db.

My problem was that I have 55 companys with 10 different modules (sections of information). I wanted to report on one module per company (I know its a lot of reports, but thats how they want it) so I thought to merge the information into the word template by adding a query i.e. [CompanyName] = "CompanyA". Saved the document "CompanyA.doc". I then added a hyperlink to the webpage and linked it to that document.

I then went back into my db and changed a value but when opening the CompanyA.doc, it stills has the old data. As you can tell, I am a little naive when it comes to ODBC etc.

Is there a way of keeping the data upto date or will I have to create the documents each time I edit something?

Any advice will do.

Thanks
Smilla

 

[smilla]

Just an idea,

Could i set a macro to run from the merge template on open. If so, I would have to pass a parameter to the word document from the hyperlink.

For instance, c:/CompanyA.doc&Value="7"

and when the merge template opens the merge report, it takes the criteria from the parameter and opens the necessary information.

Stab in the dark really because I know you can do this with other software but Word is a bit basic.

Thanks