Link Access query to Word document

[jjarman]

Is it possible to link a field in Access to a footer in Word?

I have a field in Access that would look like the following;

G10E-PRO-001RevA

Additional data in access would have the document name, and revision, matching 2 lines of text in Word. I would like the footer in the document to be the above sample, which I assume could be a query that need to run to match the 2 fields of information.... not really sure if this is even possible? Any ideas?

 

[Trevor G]

Would Mail Merge in the Word Document work for you?

 

[jjarman]

It might work... but I believe it would still need to run a query, comparing the title and revision of the document, to a record in the database so that it only returned 1 record to merge.