How do I insert different pictures using and If statement in Word.

[Rob69]

I am trying to do a mail merge from Access and I need different pictures to
display depending on certain criteria. How do I write the IF statemet to
pull various pictures depending on that criteria?

 

[Peter Jamieson]

You can put INCLUDEPICTURE fields in the results of an IF

{ IF { MERGEFIELD pictype } = "large"
"{ INCLUDEPICTURE "c\:\mypics\\large.jpg" }"
"{ INCLUDEPICTURE "c:\\mypics\\small.jpg" }" }

You can add more branches to the IF

{ IF { MERGEFIELD pictype } = "large"
"{ INCLUDEPICTURE "c:\\mypics\\large.jpg" }"
"{ IF { MERGEFIELD pictype } = "medium"
"{ INCLUDEPICTURE "c:\\mypics\\medium.jpg" }"
"{ INCLUDEPICTURE "c:\\mypics\\small.jpg" }" }" }

You may be able to have a sequence of separate IFs

{ IF { MERGEFIELD pictype } = "large"
"{ INCLUDEPICTURE "c:\\mypics\l\arge.jpg" }"
"" }{ IF { MERGEFIELD pictype } = "medium"
"{ INCLUDEPICTURE "c:\\mypics\\medium.jpg" }"
"" } { IF { MERGEFIELD pictype } = "small"
"{ INCLUDEPICTURE "c:\\mypics\\small.jpg" }"
"" }

You may find it better to put the IF inside the INCLUDEPICTURE

{ INCLUDEPICTURE "{ IF { MERGEFIELD pictype } = "large"
"c:\\mypics\\large.jpg"
"{ IF { MERGEFIELD pictype } = "medium"
"c:\\mypics\\medium.jpg"
"c:\\mypics\\small.jpg" }" }" }

Or you can put the path in a bookmark first - something like:
{ IF { MERGEFIELD pictype } = "large"
"{ SET picpath "c:\\mypics\\large.jpg" }"
"" }{ IF { MERGEFIELD pictype } = "medium"
"{ SET picpath "c:\\mypics\\medium.jpg" }"
"" } { IF { MERGEFIELD pictype } = "small"
"{ SET picpath "c:\\mypics\\small.jpg" }"
"" }{ INCLUDEPICTURE "{ REF picpath }" }

In some cases you may be able to build the name from your criteria

{ INCLUDEPICTURE "c:\\mypics\\{ MERGEFIELD pictype }.jpg" }

In all cases, all the {} need to be the spcial field code braces that you
can insert using ctrl-F9

Peter Jamieson

 

[GTS]

You can put INCLUDEPICTURE fields in the results of an IF
SNIP>
In some cases you may be able to build the name from your criteria

{ INCLUDEPICTURE "c:\\mypics\\{ MERGEFIELD pictype }.jpg" }

In all cases, all the {} need to be the spcial field code braces that you
can insert using ctrl-F9

Peter Jamieson

Not the OP but I tried this above example to merge signatures into a
letter - something like {INCLUDEPICTURE "c:\\mypics\\{MERGEFIELD
USERNAME}.gif"}. I made sure the .gif files were named the same as the
resulting USERNAME fields- i.e. JOE BLOGGS.gif, but it did'nt work for some
reason. I thought maybe because the USERNAME has a space in the middle? This
cannot be changed , the fields come from a specialised S/W package...any
ideas? It would be great to get it working.
Graham