Works Suite: Word Uses Microsoft Query When You Try to Filter and Sort a Mail Merge (261141)

SYMPTOMS

When you create a mail merge document with Microsoft Word, and you then you try to filter and sort the document (on the Tools menu, point to Mail Merge, and then click Filter and Sort), or you click Query Options in the Mail Merge Helper dialog box (click Mail Merge Helper on the Mail Merge toolbar), Microsoft Query may start instead of Query Options.

Or, the following message may appear

Word detected Microsoft Query on your system. Would you like to edit name using Microsoft Query?

where name is the name of the data source.

CAUSE

This behavior can occur when you have installed Microsoft Office and Microsoft Works Suite 2000 on the same computer, and Word was loaded with both programs. Microsoft Query was installed when you installed Microsoft Office.

Microsoft Query automatically starts if you start Word by using the Works Task Launcher.

The message described in the "Symptoms" section appears if you start Word. To do so, click Start, point to Programs, and then click Microsoft Word.

RESOLUTION

To resolve this issue, remove Word and Microsoft Query from the Office program. To remove Word and Microsoft Query, follow these steps.

Note When you use this procedure, Microsoft Query is no longer available to your other Microsoft Office programs. If you want Microsoft Query to be available to your other Office programs, see the "Workaround" section of this article.

Insert Microsoft Office 2000 CD 1.
Click Start on the Windows taskbar, and then click Run.
Type drive:\Setup.exe in the Open box, where drive is the name of your CD-ROM drive.

Click OK.
Click Add or Remove Features.
Click the arrow next to Microsoft Word for Windows.
Click Not Available.

A red X appears next to Microsoft Word for Windows.

Note If you do not remove Word at this point, the next time you attempt to use Filter and Sort or Query Options, the computer may try to use Microsoft Query, and if Query is not available, you are not allowed to complete the action.
Click the plus sign (+) next to Office Tools.
Click the arrow next to Microsoft Query.
Click Not Available.

A red X appears next to Microsoft Query.
Click Update Now, and then follow the instruction to complete the removal of these features.

Note The next time that you start Word, you may be instructed to type the Works Suite product key.

MORE INFORMATION

To work around this issue and still have Microsoft Query available, follow these steps:

Start Word from the Start menu and not from the Works Task Launcher.

Note If Word does not appear on the Start menu, click Microsoft Windows Help on the Help menu, type add a program on the Search tab, click List Topics to view a list of topics, and then click To add a program to the Start or Programs menu to view the topic.
When you want to filter, sort, or use query options, you may receive the following message:
Word detected Microsoft Query on your system. Would you like to edit name using Microsoft Query?
where name is the name of the data source.

Click No if you are using the Works Address Book or a Works database as the data source.

CAUTION: If you click Yes to this message, the Works Query Options dialog box is no longer available to you, and you have to restart the document to use the Works Query Options.