View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merging pictures along with data...

While previewing the mail merge main document, use Alt-F9 to view the field
codes, then select { MERGEFIELD IDPicture }, right-click and select the
Toggle field code option. You should now see the complete file path name.
Apart from the doubled-up backslashes, is it /exactly/ the same as the
actual full path name of one of your images? (No extra spaces at the
beginning or end or around the file name, for example)

Peter Jamieson
"Evan Lapka" Evan wrote in message
...
perhaps I'm not doing something right, but after I enter in
{ INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d } with
the modified file parameters, etc... the text just disappears and no image
is
present.

"Peter Jamieson" wrote:

Put the the full pathname of the ID picture in a cell in Excel (you may
also
have to double up any backslashes in the name, or use single forward
slashes, e.g.

c:\\my id pictures\\xyz.jpg
or
c:/my id pictures/xyz.jpg

Let's suppose you put the filenames in a column called IDPicture.

Then use the following nested field in Word:

{ INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }

(both pairs of {} have to be the special field codes you can insert using
ctrl-F9)

Alternatively, if all the pictures are in the same folder, say c:\my id
pictures, thenyou can put just the file name "xyz.jpg" in the IDPicture
column and use

{ INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }

(Make sure there are no spaces that shouldn't be there).

Then merge to a new document, ctrl-A to select it, and press F9 to update
the fields to see the different pictures.

Peter Jamieson


"Evan Lapka" wrote in message
...
I'm currently working on a database of employees for my supervisor. I'm
making individual profiles of employees by using the mail-merge feature
in
Microsoft word to take the data from the spreadsheet and filter it into
word
documents. This part is going wonderfully... BUT, my supervisor told me
today
that he wants ID pictures included with each profile. Is there a way
for
me
to insert a picture into a cell on the spreadsheet so that mail merge
will
automatically sort the pictures to the correct files along with the
rest
of
the data? Any input would be greatly appreciated, thanks!