PUB2000: Jet VBA Error Starting Mail Merge in Publisher 2000

When you click Open Data Source, Create Publisher Address List, or Edit Publisher Address List on the Tools menu, you may receive the following error message: You may then receive the following error:

This message may appear in the following situations:

• The Jet VBA file is not installed on your computer. This file is required by Publisher to perform a mail merge. This file may be missing if you uninstalled Microsoft Office or a Microsoft Office program, such as Microsoft Word, Microsoft Excel, or Microsoft PowerPoint.
• The Jet VBA file (or one of its component files) is corrupted or an incorrect version. For example, this message may appear if you have both Jet 3.0 and 3.5 installed on your computer.

To resolve this problem, use one of the following methods.

Method 1: Reinstall Publisher

To reinstall Publisher, follow these steps:

1. Insert the Publisher compact disc into your CD-ROM drive.
2. On the Windows Start menu, point to Settings, and then click Control Panel.
3. Double-click the Add/Remove Programs icon.
4. In the list of installed files, click to select Microsoft Office 2000 Disk 2. Click Add/Remove.
5. Click Repair Office. Follow the instructions on your screen.

Method 2: Copy the Mail Merge Files from the Compact Disc to the Hard Disk

Copy the following files from the compact disc to the \Windows\System (Windows 9x) or \Windows\System32 (Windows NT) folder on your hard disk.

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Publisher uses the Jet database engine to retrieve data for a mail merge. It handles the data and has the ability to read and write many common database, spreadsheet, and text file formats. The Jet engine works in the background, so you do not need to interact with it directly. It ships with Microsoft Publisher and other programs.

Publisher installs the following files as part of the mail merge feature:



The following files require additional registry information for the mail merge feature in Publisher 2000 to work.

• Dao360.dll
• Msxbde40.dll
• Mstext40.dll
• Msrd2x40.dll
• Msvcp60.dll

For more information about the mail merge feature, please see the following article in the Microsoft Knowledge Base: