Microsoft KB Archive/198239

= PUB2000: Mail Merge: How to Import a Works Database =

Article ID: 198239

Article Last Modified on 6/29/1999

-

APPLIES TO


 * Microsoft Publisher 2000 Standard Edition

-



This article was previously published under Q198239





SYMPTOMS
If you try to use a database created in Microsoft Works as the data source for a mail merge in Publisher, you may receive the following error message:

Publisher cannot import a Works database that includes formulas.



CAUSE
This will occur if you created your Works database using the TaskWizard.

By default, when you use the TaskWizard to create a database, it inserts a field called TDate. This field contains a formula. Depending on what type of database you create, there may be other fields that contain formulas as well. Publisher cannot use a database that contains formulas as a source for a mail merge.



RESOLUTION
To work around this problem, use any of the following methods.

Method 1: Remove the Formulas from the Database
 Start Works and open the database (.wdb) file. On the File menu, click Save As. Save the database file with a different name. On the View menu, click List.

This will display your database in table form, with the fields listed across the top of the screen, and each row representing one record. Identify which fields contain formulas by doing the following:  Click the cell that represents the first field of the first record. Look at the formula bar at the top of the screen. If the data in the formula bar starts with an equal sign, that field contains a formula. By default, the field called Tdate will contain the formula

=NOW Click the cell representing the second field of the first record. Look at the formula bar to see if this field contains a formula.</li> Repeat this process for the rest of the fields.</li></ol> </li> When you locate a field that contains a formula, remove the formula. To remove a formula, follow these steps: <ol style="list-style-type: lower-alpha;"> Click the field name at the top of the screen to select it.</li> On the Format menu, click Protection.

Make sure there is no mark in the Protect Field box.</li> Click OK.</li> On the Edit menu, click Clear Formula.</li></ol> </li> After you have cleared all the formulas, click Save on the File menu.</li></ol>

You now have a copy of the database; use this copy as a data source for the Publisher Mail Merge.

NOTE: Be sure to use this copy instead of the original file.

Method 2: Save the Database as a Text File
<ol> Start Works and open the database (.wdb) file.</li> On the File menu, click Save As.</li> In the Save File as Type list, click Text & Tabs.</li> Type a file name in the File Name box. Click OK.

You can use this text file as a data source for a Publisher Mail Merge. When you open this data source in Publisher, Publisher will ask:

Do you want to use the entries in the first row of your data as field names?

Click No. If you click Yes, you may receive the following error:

Microsoft Publisher cannot import your data source because it contains more than one field with the same name. Please rename any duplicate fields and try again.

</li></ol>

<div class="status_section">

STATUS
Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: pub9 w_mspub winworks mspub 9.0 9.00 2000 mspub9 mspub2k

Keywords: kbprb kbfaq KB198239

-

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

© Microsoft Corporation. All rights reserved.