Below are the steps to create a mail merge report using MS Access and Word:
- In the 'Access ribbon', go to the 'External Data' tab.
- Go to the 'Export' group and select 'Word Merge'.
- Follow the 'Word Mail Merge Wizard' select from the options below and click 'OK'.
- Select the type of document you want to create and click 'Open'.
- Place the cursor where you want the field to appear in the document.
- Click on the 'Insert Merge Field' button on the Mailings tab to add fields from your Access table.
- Select fields and click 'Insert'.
- Click the 'Preview Results' button in Word to review how the merged data will appear.
- If everything looks good, click 'Finish & Merge'.
- Decide on what to do with your document. You can print the documents, edit individual documents, or save the merged output.
