View Single Post
  #2  
Old April 20th, 2005, 08:11 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

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

"Rob69" wrote in message
...
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?