Advanced: Requires expert coding, interoperability, and multiuser skills.

This article describes how to start the Mail Merge Wizard without using the Merge It button on the toolbar.

Back to the top

The Mail Merge Wizard helps you merge data from a Microsoft Access table or query with a form letter or other document in Microsoft Word. You can start the Mail Merge Wizard by clicking the Merge It button on the toolbar.

To start the Mail Merge Wizard without using the Merge It button, call the PM_Entry() function from within your application. Make sure to supply the function with a valid table or query name as an argument. For example, to merge the data in the Customers table with a Microsoft Word document by clicking a command button on a form, you would specify the following setting for the command button's OnClick property:

   =PM_Entry("Customers")
				

NOTE: In Access 2.0, WZLIB.MDA must be loaded in the [Libraries] section of your MSACC20.INI file for this function to be available. If WZLIB.MDA is not loaded as a library, you cannot run the PM_Entry() function.

To set this reference in Microsoft Access 95, go to any Access Basic module, click References from the Tools menu, and make sure wzmain70 is clicked.

To set this reference in Microsoft Access 97, go to any Access VBA module, click References from the Tools menu, and make sure wzmain80 is clicked.

Back to the top

Microsoft Access "User's Guide," version 2.0, Appendix D, "Using Other Windows-Based Applications with Microsoft Access," page 739

In Microsoft Access 95, click Answer Wizard from the Help Menu and type Mail Merge. Next, click the Search button to get a list of topics.

In Microsoft Access 97, click Contents and Index from the Help Menu, Select the Index tab and type Mail Merge, (include the comma). Next, Click the Mail Merge topic.

Back to the top