Article ID: 113705
Article Last Modified on 8/16/2005
APPLIES TO
- Microsoft Word 6.0 Standard Edition
- Microsoft Word 6.0a
- Microsoft Word 6.0c
- Microsoft Word 95 Standard Edition
- Microsoft Word 95a
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 95a
This article was previously published under Q113705
SYMPTOMS
If you specify a range when you attach a Microsoft Excel for Windows spreadsheet as a mail merge data source using dynamic data exchange (DDE), the following error messages may occur
followed by:
CAUSE
Case 1: Selecting Ignore Other Applications
This error occurs if the Ignore Other Applications check box in Microsoft Excel is selected. To locate this option in Microsoft Excel, click Options on the Tools menu, and then click the General tab.
Case 2: Using a Colon to Specify a Range of Cells
Word 7.0:
This error also occurs if you use a colon to specify a range of cells. For example, if you specify a range by typing "A1:G6" or "R1C1:R6C7" in the Microsoft Excel dialog box that appears after you select a spreadsheet, this error occurs. If you use a different separator-- such as a comma, period, or semicolon--the data source opens as expected.
Word 6.0:
This error occurs if you use a colon (:) to specify a range of cells you want to use. For example, if you specify a range by typing "A1:G6" or "R1C1:R6C7" in the Microsoft Excel dialog box that appears after you select a spreadsheet, this error occurs. If you use a different separator--such as a comma, period, or semicolon--Word does not attach the spreadsheet at all.
WORKAROUND
Case 1: Selecting Ignore Other Applications
In Microsoft Excel, clear the Ignore Other Applications check box and use a name to define the range of data you want to use as the mail merge data source. In Word, when the Microsoft Excel dialog box appears, select that name in the Named or Cell Range list. This method works whether you open the spreadsheet using DDE or the Microsoft Excel converter.
Case 2: Using a colon to specify a range of cells
On the Tools menu, click Mail Merge, click the Get Data button, and click Open Data Source. Ensure that the Confirm Conversions check box (Word 6.0) or the Select Method check box (Word 7.0) is selected. When Word prompts you to confirm the data source, select Microsoft Excel Worksheet Via Converter (*.xls) from the Open Data Source list. When you use the converter, the error does not occur, even if you specify a range using a colon as the separator.
MORE INFORMATION
Word Help contains incorrect information in the Microsoft Excel Dialog Box Help topic. This Help topic states the following:
Select a named range of cells or type the row and column references you want to use from the worksheet. For example, A1:C5 includes the information in cells A1 through C5.
Typing the row and column references will not produce the results you expect.
Additional query words: mail DDE delimiter winword cell range separator colon comma semicolon semi-colon officeinterop merge mailmerge excel reestablish
Keywords: kbinterop kbprint kbmerge KB113705