WD98: Merge Data Source Saved as Word Document

Last reviewed: February 17, 1998
Article ID: Q179312
The information in this article applies to:
  • Microsoft Word 98 Macintosh Edition

SYMPTOMS

If you use a Microsoft Excel worksheet as a mail merge data source, Word saves the worksheet in Word document format if you choose Yes when Word prompts you to save the data source. In other words, Word overwrites the Microsoft Excel worksheet with a Word document if you choose Yes in response to the following message:

   <Document Name> is a mail merge main document that is attached
   to a data source <Worksheet Name> that has not been saved. Do
   you want to save <Worksheet Name>?

Word does not warn you that the Microsoft Excel worksheet will be overwritten with a Word document.

WORKAROUND

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

Method 1: Not using File Type Excel Worksheets via DDE

If your mail merge data source is a Microsoft Excel worksheet, do not modify it by clicking the Edit Data Source button on the Mail Merge toolbar in Word. Instead, open the worksheet in Microsoft Excel, modify it, and then save it in Microsoft Excel.

Method 2: Using File Type Excel Worksheets via DDE

This method should only be performed on Macintosh computers with at least 16 megabytes (MB) of Random Access Memory (RAM) installed.

Select the option to use a Microsoft Excel Worksheet via Dynamic Data Exchange (DDE) by doing the following when selecting an Excel spreadsheet as a mail merge data source:

  1. On the Tools menu, click Mail Merge.

  2. Under Data Source, click Get Date, and then click Open Data Source.

  3. In the Select A Data File dialog box, under List Files Of Type, click Excel Worksheets Via DDE.

  4. Select your Excel spreadsheet, and then select Open.

  5. Select a Named or Cell Range, and then click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

When you use an Excel data source via Dynamic Data Exchange (DDE), the DDE operation requires that Excel be started, which opens up a channel between Excel and Word to supply the data to Word for the merge operation. When you click the Edit Data Source button (on the Mail Merge Toolbar), Excel comes to the foreground. You can make your changes in Excel, and then save the file. After you complete the merge, the Excel file is preserved.

For additional information about this problem in an earlier versions of Microsoft Word for Macintosh, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q179307
   TITLE     : WD6X: Merge Data Source Saved as Word Document


Additional query words: macword98
Keywords : macword kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Hardware : MAC
Issue type : kbbug
Solution Type : kbfix


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 17, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.