Merging between Access and Word

L

Lace

I am doing a merge from Access into a Word document. The graphic fields in
Access are showing up as "151C1D00" after I merge into word. Does anyone
know how can I have the pictures show in word after I merge?
 
P

Peter Jamieson

You can't merge the image data in access directly into Word. The best you
can do is maintain copies of the images in files outside the database in a
format that Word can insert using an INCLUDEPICTURE field, and keep enough
information in the record that the image comes from to build the file name
of the image. For example, if each record has a unique numeric key called ID
wwith values 1,2,3, etc., then you might save each image as

c:\myimages\img1.jpg
c:\myimages\img2.jpg
c:\myimages\img3.jpg

etc., then use the following nested field in Word:

{ INCLUDEPICTURE "c:\\myimages\\img{ MERGEFIELD ID }.jpg" \d }

All the {} have to be the special field code braces you can insert using
ctrl-F9.

Then you may also have to output your merge to a new document, select it
all, and press F9 to update the fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top