Forum Discussion
Macro to Create Multiple Word Documents with Links to Excel Records
Your question has languished for a few days without as much as a single reply. It would be great to be able to offer help. I can make a couple of observations, but it's hard to know exactly how to help. If you had some sample records (devoid of confidential info) that could help.
My first reaction is that you shouldn't need a macro or VBA routine to make mail merge work; that's part of the beauty of that arrangement.
You DO need to figure out a way to handle those regular updates. My own suggestion would be to have a date field added to each row and to make that a part of your record selection criteria in the Word MailMerge screen, so you're only creating the merge for updated records. (Of course that depends in part on how those records get updated, but I'm presuming there's a human agent involved since these look pretty text intensive.)
If you're still looking for resolution, consider uploading sample data...and describe a bit more the nature of updates, how they happen...