ACC2000: Changing Your Data Source for a Word Mail Merge

This article was previously published under Q198925
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

When you use the Microsoft Word Mail Merge Wizard to merge your data into aWord document, it is possible to use an existing Word document that hasbeen previously merged with a different data source. This articledemonstrates how to do this.
To change the data source for a Microsoft Word Mail Merge document, followthese steps:
  1. Open your database in Microsoft Access.
  2. In the Database window, select the new data source that you want to use with your existing Word document.
  3. On the Tools menu, point to Office Links, and then click Merge It with MS Word.
  4. On the first screen of the Microsoft Word Mail Merge Wizard, clickLink your data to an existing Microsoft Word document, and then click OK.
  5. In the Select Microsoft Word Document box, select the existing Microsoft Word document that you want to use, and then click Open.
  6. Microsoft Word opens with the following message:
    The data source of the document you selected is different from the source you selected when starting the Mail Merge Wizard. Would you like the Mail Merge Wizard to change the source?
  7. Click Yes. The new fields for the data source are now available for you to insert into your document.
For more information about merging data with Microsoft Word, click Microsoft Access Help on the Help menu, type mail-merge wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
inf datasource source export

Article ID: 198925 - Last Review: 12/05/2015 10:19:47 - Revision: 2.0

Microsoft Access 2000 Standard Edition, Microsoft Word 2000 Standard Edition

  • kbnosurvey kbarchive kbhowto kbinterop KB198925