Includepicture Problem Word 2002

Q

quail1

I have been trying to merge a graphic image into a word doc and have been
unable to get it to work. My source is an Excel file with columns for
"First & Last Name" and "Pictures" . Each field in the picture column has a
reference to an image, all of which are in the C:\ directory, e.g.
"C:\\photo1.jpg", C:\\photo2.jpg", etc. I included the following in the
Merge doc using the ctrl F9 key to put in the brackets and then the insert
merge field button to add the pictures field:

{INCLUDEPICTURE {MERGEFIELD "pictures"}}



The result when I merge is a picture placeholder with an x in the upper left
hand corner but no image. This happens even when I select all and update
using the F9 key. I know I'm doing something wrong but I can't figure out
what. Any help would be greatly appreciated.



Gene Rohr



ps if I include a direct reference to the image in the INCLUDEPICTURE
statement e.g. {INCLUDPICTURE "C:\\photo1.jpg"} the picture does show up.
 
G

Graham Mayor

The problem here is a conflict between what is stored in the data file and
what the filename of the image you are trying to merge,
The first step would be to insert a Pictures field in a temporary merge
document to see what it actually returns rather than what you think it
should return, then make up the rest of the field to give you the correct
path and filename, supplemented by the field content, so you may produce
someing like

{IncludePicture "C:\\Path\\{Mergefield Pictures}.jpg"}

or whatever it takes to give you INCLUDPICTURE "C:\\photo1.jpg"

See http://www.gmayor.com/mail_merge_graphics.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail [email protected]
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Top