Help to merge Image (Doug Robins?)

[JohnB]

Thanks for such a comprehensive reply.

I dont have the knowledge to allow me to do the things you suggest so I
think Ill just have to accept that I cant merge Images in the way I want to.
Still, it was interesting. I know a lot more about mail merge than I did at
the start.

Thank you for all of your help and for being patient.

Cheers, JohnB

 

[Peter Jamieson]

You don't need it. It just changes the case of the text to upper case.

Peter Jamieson

Sorry I didn't see the coding didn't paste.
{ INCLUDEPICTURE c:\\cbs\\pubpics\\{ MERGEFIELD "PicRef" \* upper }.jpg}
by the way what dose the [ \ * upper ] refer to?
--
All the Best
Bob K

Hi folks
I have been following your discussion intensely since yesterday afternoon
to
22/6/05 when I started to do the same exercise. I think you've already
cracked it. The coding I'm using is and that is using just a straight
reference code in the worksheet all the extensions are in the merge
field.
What you have to do is merge to a new document or your pages press Ctrl+A
to
select all the fields and then press F9 to update all the fields you will
now
find that your pictures are in the right place. I'm working with office
word
2003 and Excel I am assuming this is going to work with the earlier
versions
that you're working with. This is fine if you've got a picture for each
page
otherwise it appears to default to the picture that was there before the
mail
merge. My thought to get around this is possibly set up the mail merge
with a
dummy image saying no PICTURE AVAILABLE unless anybody has a better
suggestion.
I thank you all for your help it has been very interesting and I'll keep
watching this space.