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:
- From the database window, select the table or query that contains the information you want to merge into your mailing documents.
- On the Database toolbar, click the drop-down arrow of the OfficeLinks button.
- 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 active.
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.