Mailmerge question
Macropod,
Tried a different piece of code whose syntax is probably all wrong but
anyway:
{ INCLUDEPICTURE "O:\\Pictures\\2009 Original Church Pictures\\{ IF {
FILENAME "O:\\Pictures\\2009 Original Church Pictures\\{ MERGEFIELD
Full_Name}.jpg"}= "" "NoPicture" { MERGEFIELD "Full_Name" }}.JPG" }
Unfortunately this didn't work either. :-(
By the way, I have the NoPicture.jpg in both 2009 Original Church Pictures
folder and the folder in which all of my merge files are located. Made no
difference.
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
With best regards, colblip. E-mail: colonel.blip.at.bigfoot.com
Hello, macropod!
You wrote on Sat, 8 Aug 2009 23:41:02 +1000:
m The field code you're using, which reduces to:
m {INCLUDEPICTURE "O:\\Pictures\\2009 Original Church
m Pictures\\{IF{MERGEFIELD "Full_Name"}= "" "NoPicture" {MERGEFIELD
m "Full_Name"}}.JPG"} is correct.
m I've been doing further testing and have found that the symptoms
you've m identified (ie the picture from the previous record being
inserted) m occurs with Word 2007 if the file named 'NoPicture' does
not exist in m the image folder. Although this seems to be a bug in
Word 2007, it also m says the file named 'NoPicture.jpg' isn't in
that folder - either it has m another name or it's in a different
folder.
m --
m Cheers
m macropod
m [Microsoft MVP - Word]
|