Mail Merge with Word and Access

This example assumes that you have a mail merge task that you would like to perform with information that currently exists in an Access database.  If you do not currently have an Access database, modify the instructions in the Database How-To to construct a small address book which would work well for this task. We will use Microsoft Word along with Access to accomplish our task.

  1. Click | Start | Programs | MS Access
  2. Select Open "an existing database" | Select the appropriate filename | click OK
  3. From the Office Links Toolbar button Select "Merge IT with MS Word
  4. Select the "Create New Document and Then Link the Data to it" Radio Button | Click OK
  5. When MS Word opens Type your letter - stopping to insert merge fields into it by selecting the "Insert Merge Fields" which will be available above the top and to the left-hand side of the document window.
  6.  Select the Mail Merge Button - third from the end on the right of the Mail Merge Toolbar (where the "Insert Merge Fields" button resides)
  7. Select as New Document, Printer, or Electronic Mail as the "Merge To" destination with the drop down list in the dialog | Click Merge
You have now merged your Access database with an MS Word document. This produces a customized output from a form letter to multiple recipients.

Back to Tom's Site
Last Updated 7/1/2001
Copyright 2001 T.C. Spencer