update merged word file

[Kim]

I have created a template in word to which I merged a
database query. Is there a way to make it so that when I
update the tables in Access, the fields in Word will be
updated with the new info?? Thanks

 

[John Nurick]

Hi Kim,

When you do a mailmerge, Word creates a new document in which the
mergefields are replaced by the actual text from the database, so
there's no way to update the merged document: you need to run the
mailmerge again to create a new merged document containing the current
data.

Alternatively there are ways of putting fields (not mergefields) in a
Word document and making them update from the database on demand.

I have created a template in word to which I merged a
database query. Is there a way to make it so that when I
update the tables in Access, the fields in Word will be
updated with the new info?? Thanks

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Larry Daugherty]

You can add some code at the point(s) where you finish updating the tables
in Access that will open Word and your merge document. Look up "Automation"
in Help. You might want to initially write your code behind a command
button for debugging.

HTH