Article ID: 114306 - View products that this article applies to.
This article was previously published under Q114306
When you use a Microsoft Access or Microsoft FoxPro database in a Word document (for example, a Word mail merge), pictures in the database do not appear.
When you use DDE (dynamic data exchange) to insert the database, you receive the following error message in Word, in place of the picture:
When you use ODBC (Open Database Connectivity) to insert the database, the picture area is blank in Word, and no error message appears.
Long binary or text value.
Note This problem can occur with any database program that interfaces via DDE with the Word mail-merge or database features.
Neither DDE nor the implementation of ODBC in Microsoft Word supports the long binary format that is used to store pictures in a database.
To work around this problem when you use a database in a Word mail merge, store the path information to each picture in your database file. For example, create a Picture column in your database, and then type the full path to the appropriate picture in the record.
Note When you type the full path to the picture into your database file, be sure to enclose the path within quotation marks and to use double-backslashes, as in the following example:
"C:\\Documents\\Pictures\\Picture001.jpg"Then, in Microsoft Word, follow these steps:
See page 677 in the "Microsoft Word User's Guide" for information about selecting DDE or ODBC as the conversion method.
"Microsoft Word User's Guide," version 6.0, pages 624-632, 676-677
Article ID: 114306 - Last Review: January 18, 2007 - Revision: 3.3