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.microsoft.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.

 

[GaryPanic]

why ??- just use the super easy word fuction

 

[TommyGunn]

I must be out of the loop..

 

[Mike375]

Scroll about half way down until you get to Super Easy Word Merge

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[TommyGunn]

Thanks so much, I'll give it a try.