Microsoft KB Archive/268757

= Works: Word Processor Cannot Merge Records from Works Spreadsheet Document Saved As Excel =

Article ID: 268757

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * 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.</li> Start Works Word Processor.</li> On the Tools menu, point to Mail Merge, and then click Open Data Source.</li> Click Merge information from another type of file.</li> In the Files of type box, click Microsoft Excel(*.xls).</li> Locate and click the test.xls file, and then click Open.</li> When the message about using entries in the first row appears, click Yes.</li> In the Name box, type Sheet1, and then click OK.</li> Place the insertion point where you want the NAME field to appear, click NAME, and then click Insert.</li> Repeat step 14 for CITY and STATE.</li> Click View Results to view the merge results.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: works6 w_works

Keywords: kbbug kbinterop kbpending KB268757

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.