Works: Word Processor Cannot Merge Records from Works Spreadsheet Document Saved As Excel (268757)
The information in this article applies to:
- Microsoft Works 6
- Microsoft Works 7.0
- Microsoft Works Suite 2001
- Microsoft Works Suite 2002
- Microsoft Works Suite 2003
This article was previously published under Q268757 SYMPTOMS
When you create a Microsoft Works Spreadsheet document, and you then save the document as a Microsoft Excel 97-2000 (*.xls) file, the .xls file cannot be used as a mail merge data source by Works Word Processor.
CAUSE
This behavior occurs because Works does not assign a sheet number to the spreadsheet when it is saved as an Excel 97-2000 (*.xls) file.
RESOLUTION
To work around this issue, save the spreadsheet as an Excel 5.0/95 (*.xls) file. This file type is compatible with Excel 97-2000 and with Works Spreadsheet, and it can also be used as mail merge data source with Works Word Processor.
To save a Works Spreadsheet document as an Excel 5.0/95 ( *.xls) file and use it as a mail merge data source, follow these steps:
- Start Works Spreadsheet.
- Type the following data in a new spreadsheet:
A1: NAME B1: CITY C1: STATE
A2: Gary B2: Gary C2: Indiana
- On the File menu, click Save As.
- In the Save as type box, click Excel 5.0/95(*.xls).
- In the File name box, type test.
- Click Save.
- Start Works Word Processor.
- On the Tools menu, point to Mail Merge, and then click Open Data Source.
- Click Merge information from another type of file.
- In the Files of type box, click Microsoft Excel(*.xls).
- Locate and click the test.xls file, and then click Open.
- When the message about using entries in the first row appears, click Yes.
- In the Name box, type Sheet1, and then click OK.
- Place the insertion point where you want the NAME field to appear, click NAME, and then click Insert.
- Repeat step 14 for CITY and STATE.
- Click View Results to view the merge results.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 6/25/2003 |
---|
Keywords: | kbbug kbinterop kbpending KB268757 |
---|
|