ACC2: How to Start the Mail Merge Wizard Without the Toolbar

• Microsoft Access versions 2.0, 7.0, 97

SUMMARY

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.

MORE INFORMATION

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")

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.

REFERENCES

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.