Mailmerge question
Have you seen my response in the other thread?
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"colblip" colonel.blip.at.bigfoot.com wrote in message
...
Macropod,
Thanks for the fieldtotxt item link. Here is my converted code, including
the bold formatting code:
{ INCLUDEPICTURE "O:\\Pictures\\2009 Original Church
Pictures\\{ IF { MERGEFIELD "Full_Name" }= ""
"NoPicture" { MERGEFIELD "Full_Name" }}.JPG"
}
Maybe this will help point out my error.
Thanks.
Colblip
Macropod,
Yes, I double checked to make sure and it is there with that name
and is the 'picture' I want to add.
macropod,
Tried the code and result was correct picture for each record
that had a picture but for those that didn't rather than
NoPictureAvailable.jpg being used the picture from the previous
record is repeated.
Hello, All!
I have a directory I print for the church. In it I have
insert a picture of the family with the code
{INCLUDEPICTURE "O:\\Pictures\\2009 Original Church
Pictures\\{ Mergefield "Full_Name"}.JPG" }. I would like to
insert a standard NoPictureAvailable.jpg file if there is no
picture for the family in question. Is there a way to do
this? Thanks,
Colonel Blip
E-mail: colonel.blip.at.bigfoot.com
With best regards, colblip. E-mail:
colonel.blip.at.bigfoot.com
Hello, macropod!
You wrote on Thu, 6 Aug 2009 11:26:13 +1000:
m You could use:
m {INCLUDEPICTURE "O:\\Pictures\\2009 Original Church
m Pictures\\{IF{ Mergefield "Full_Name"}= ""
"NoPictureAvailable"
{ m Mergefield "Full_Name"}}.JPG" }
m --
m Cheers
m macropod
m [Microsoft MVP - Word]
With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com
Hello, macropod!
You wrote on Fri, 7 Aug 2009 09:35:14 +1000:
m Do do actually have a jpg file named 'NoPictureAvailable.jpg'
in m O:\Pictures\2009 Original Church Pictures\?
m --
m Cheers
m macropod
m [Microsoft MVP - Word]
With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com
Hello, macropod!
You wrote on Fri, 7 Aug 2009 21:06:27 -0500:
m I checked, double checked, re-entered and checked again. Code is as
you m recommended. I then did a mail merge and alt-F9. The photos
that exist m for each record show up correctly. However those records
for which there m is no photo, instead of the NoPictureAvailable.jpg
showing in the code m it is the Full_Name.jpg that is called for
(which of course doesn't m exist).
m So for some reason the IF test is not responding correctly. Is
there a m way I can post a picture of the code for you (since I've
yet to figure m out how to copy the code exactly as entered and paste
it here)?
m OK, select the whole output file (Ctrl-A) then press F9 to update
all m the images. If the image that is supposed to be represented by
m 'NoPictureAvailable.jpg' now shows, the only problem was with the
field m updates
m If the image that is supposed to be represented by
m 'NoPictureAvailable.jpg' doesn't now show the correct image, the
next m step is to examine the output field code. To do that, press
Alt-F9 to m toggle the field display. Then check what's displayed in
the field that m is supposed to show your 'NoPictureAvailable.jpg'
image. If it's not m there, there's a problem in the way you've
coded the IF test - you need m to pay careful attention to the use
of spaces and double quote m characters. If it is there, you need to
re-check the name in the field m code against the file's name.
m --
m Cheers
m macropod
m [Microsoft MVP - Word]
m "colblip" colonel.blip.at.bigfoot.com wrote in message
|