Live Chat Software by Kayako |
Knowledgebase: Microsoft Word
|
WD2000: Field Text Truncated When Merging or Inserting Database
Posted by - NA - on 23 March 2006 08:27 AM
|
|
|
Solution: Perform a Mail Merge 1. In your mail-merge main document, click Mail Merge on the Tools menu. 2. In the Mail Merge Helper, click Create and then click the type of mail merge you want to perform. For example, click Form Letters. 3. Click Active Window. 4. In the Mail Merge Helper, click Get Data and then click Open Data Source. 5. In the Open Data Source dialog box, do the following steps: a. Change the Files of type box to the type of your database. For example, if your database is an Access database, change the Files of type box to MS Access Databases (*.mdb, *.mde). b. Select the Select method check box. c. Change the Look in box to the folder containing your database file. For example, change the Look in box to C:\Program Files\Microsoft Office\Office\Samples folder. d. Click your database file. For example, click the Northwind.mdb database. e. Click Open. 6. In the Confirm Data Source dialog box, click MS Access Databases via DDE (*.mdb, *.mde), and then click OK. Insert a Database 1. In your Word document, point to Toolbars on the View menu and then click Database. 2. On the Database toolbar, click Insert Database. 3. Click Get Data. 4. In the Open Data Source dialog box, do the following steps: a. Change the Files of type to the type of your database. For example, if your database is an Access database, change the Files of type box to MS Access Databases (*.mdb, *.mde). b. Select the Select Method check box. c. Change the Look in box to the folder containing your database file. For example, change the Look in box to C:\Program Files\Microsoft Office\Office\Samples folder. d. Click your database file. For example, click the Northwind.mdb database. e. Click Open. 5. In the Confirm Data Source dialog box, click MS Access Databases via DDE (*.mdb, *.mde), and then click OK. NOTE: You may have to select a table in the Select Table dialog box. 6. In the Database dialog box, click Insert Data. 7. In the Insert Data dialog box, select the range of records you want; for example, click All and then click OK. | |
 (120 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)