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.
-
Click | Start | Programs | MS Access
-
Select Open "an existing database" | Select
the appropriate filename | click OK
-
From the Office Links Toolbar button Select
"Merge IT with MS Word
-
Select the "Create New Document and Then
Link the Data to it" Radio Button | Click OK
-
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.
-
Select the Mail Merge Button - third
from the end on the right of the Mail Merge Toolbar (where the "Insert
Merge Fields" button resides)
-
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