By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Automating Word Mail Merge Through Access

P: 7
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.
Aug 8 '08 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Aug 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.