View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
oli merge oli merge is offline
external usenet poster
 
Posts: 15
Default urgent mail merge with different pictures problem

nah tried that, tried all sorts of combinations of updating fields and
turning on and off Alt F9 but to no avail

"Graham Mayor" wrote:

You need to merge to a new document *then* select all and F9 to update.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


oli merge wrote:
Hi,

I am trying to make product labels with individual pictures in Word
(again lol). I have done this before with the help of this forum and
so am familiar with the issues and workarounds that are common and
are dealt with on Graham M's helpful site.

I am using the method of {INCLUDEPICTURE {MERGEFIELD "PhotoPath"
}\*MERGEFORMAT} as the picture and Photopath as a column in my excel
spreadsheet that contains the rest of the product info. The field
contains the path is in exactly the following format: C:\\Documents
and Settings\\oliver.merge\\My Documents\\PWC photo
labels\\pics\\PWC_FRS010.jpg

Problem is that this time I just cant get the pictures to appear
where they should. I have 10 labels to a page, and on my original
excel file the first picture is missing, so would be C:\\Documents
and Settings\\oliver.merge\\My Documents\\PWC photo labels\\pics\\.jpg

This first file being missing seemed to cause word to pick a default
image, which happens to be a picture of a telephone I took ages ago.
So this phone image appeared in the first label, followed by the rest
of the labels in the correct place.

So far so good, I then decided I want to leave out the items with no
photo, and firstly tried deselecting them in the select merge
recipients thing. This had the effect of updating the text elements
correctly, but leaving the pictures as they are, keeping in the
default phone picture and so having the pics lined up against the
wrong products.

I tried select all F9 and merging to a new document, I get various
incorrect results such as all pictures being the default phone one,
all pictures disappearing and all records changing to be the first
one. I see when pressing alt F9 that its changed the mergefield part
in the INCLUDEPICTURE command to an absolute path and so tried
starting again with a brand new INCLUDEPICTURE command with the
mergefield photopath put back in. No good, same problem.

I then tried making a brand new excel workbook with all products that
are missing pictures taken out and merged from that instead. No good,
exactly the same problem, still has the default images in where they
would be if I merged from the original data. I have tried deleting
the INCLUDEPICTURE thing and inserting a brand new one and its just
ignoring me and putting the default phone picture in again.

Im completely baffled, in fact I cant even find where the phone
picture is on my harddrive to see what happens if I delete it so I
have no idea where how or why word is finding it.

As I say, I managed to get this to work a few months ago but now am
completely stuck. The only difference is I am now using WORD 2003
instead of 2000.

please please help!