Automating Word Mail Merge Through Access

[TommyGunn]

Hi everyone,

Is there anyway to automatically put Access data into Mail Merge in an existing Word doc with content?

I have bits and pieces of this done, but I can't seem to put it all together.

I am able to manually export an Access Query to Word, and the mail merge works fine. I am also able to open Word from Access, but unfortunately the Mail Merge data does not get updated since the manual export (thinking a few days later when the address data has been updated).

I found an article (http://support.microso ft.com/kb/285332) to create a VB app to set the datasource in Word to automatically pull the data from Access. Unfortunately the article requires that the rest of the letter's content be typed in the VB code, and I need to be able to edit the content in Word.

Any ideas? Any help would be appreciated.

Thanks in advance, Tom.

[MMcCarthy]

I think you are mistaken in your understanding of mail merge. It doesn't update dynamically. Unlike Excel you don't maintain a connection to the query for live updating. Mail Merge works by using a template based on the query and a document is then created based on the data returned by the query.

If you wish the data to be updated to current data you simply need to reopen the template and recreate the document.