You don’t have to export an Access table or query before you
can use it with Word’s Mail Merge Wizard. With the OfficeLinks feature, you can
open Word’s Mail Merge Wizard from within Access.

Follow these steps:

  1. From
    the database window, select the table or query that contains the
    information you want to merge into your mailing documents.
  2. On the
    Database toolbar, click the drop-down arrow of the OfficeLinks button.
  3. Select
    Merge It With MS Word.

If you’re using Word 2002, Access displays the Microsoft
Word Mail Merge Wizard dialog box, which gives you the option of linking your
data to an existing Word document or to an entirely new document.

Selecting Link Your Data To An Existing Microsoft Word
Document displays the standard File Open dialog box from which you can select
your document. Access opens the selected document with the Mail Merge toolbar

Selecting Create A New Document And Then
Link The Data To It opens a new document with the Mail Merge toolbar
active. You can use the Mail Merge toolbar or the task pane to create and print
a merged document or labels.

If you’re using Word 2000, Access opens a new Word document
with the Mail Merge toolbar displayed. Select the Mail Merge Helper tool from
the toolbar to create and print the merge document or labels.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.