update merged word file

  • Thread starter Thread starter Kim
  • Start date Start date
K

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
 
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
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
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
 
Back
Top