mail merge

[homeless]

can someone tell me how to do a mail merge between Access and Word? Will these involve a lot of coding in VBA?

 

[tlbroadbent]

You start in Word. Choose Tools|Mail Merge. The Mail Merge wizard starts and you just need to follow instructions. No coding invloved. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[dawnd3]

No you do not need VBA. Are you trying to merge an access address list into a word document, like a letter? If so, you need to use the mail merge helper in Word. After you type your main document, you will go to the Tools menu and choose mail merge. The mail merge helper has 3 steps. Part of step one is to create the document if you haven't already done so, and then edit the main document by inserting merge fields (last name, first name, etc) in place of where you want the data to be intered into each letter. Step 2 will allow you to create or choose a data source. This is where Access comes in. After you click choose data source you will browse to find the database that has the table you want to merge. Be sure you are looking at Access files and not word files. Step 3 will allow you to Merge the 2.

This isn't the most thourough answer, but hopefully it will get you in the right direction. Look up Mail Merge in your help menu or a book on Word or Office. Dawn