Home > Microsoft Office > Access > Mail Merge - Access

Mail Merge - Access
You can create a mail merge form source for recipients of forms such as letters, emails, envelopes, or directories using Access 2016/2013/2010 and Word 2016/2013/2010. This makes it easy to enter a large amount of varying data, such as names, dates, and addresses of recipients, on the same form.
Step 1:Open your data in Access. Select the exact object (this may be the list of names and addresses) that you would like to use from the navigation pane.

Step 2:Click on the External Data tab. In the Export group, choose Word Merge.

Step 3:Choose whether you want to link the data to an existing Word document or if you need to create a new one. Click OK.

Step 4:Open the existing Word file or create the new one. Step 5:In the pane on the right, you will see that the recipients are coming from an existing list, the one from Access. At the bottom of the pane, click Next: Write your letter.

Step 6:You will need to specify the mail merge fields. Click the Mailings tab, then Insert Merge Field from the Write & Insert Fields group.

Step 7:Select the name of the field that you wish to insert first.

Step 8:Continue inserting the merge fields.

Step 9:At the bottom of the pane on the right, click Next: Preview your letters.

Step 10:You can scroll through the recipients to make sure the data is correct.

Step 11:If everything looks good, click Next: Complete the merge at the bottom of the pane on the right.

Step 12:You can choose to print the forms or edit the individual forms from the pane on the right.

Related Articles