View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Multiple criteria for mergefield

Hmmm.... IncludePicture fields do not usually work when included as a
conditional field result. The IncludePicture field has to be at the top of
the tree - see the workaround at
http://www.gmayor.com/formatting_word_fields.htm#image

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Doug Robbins - Word MVP wrote:
{ IF { MERGEFIELD A } = "Y" { INCLUDEPICTURE "DRIVE:\\PATH\\FILENAME"
} { IF { MERGEFIELD B = "Y" { INCLUDEPICTURE
"DRIVE:\\PATH\\ANOTHERFILENAME" } "" } }

You need to use Ctrl+F9 to insert the field delimiters { } and Alt+F9
to toggle the display of field codes and F9 to update the fields.

See the "Graphics from data base" item under the "Special merges"
section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindy...r/MergFram.htm



"gilbertj" u23713@uwe wrote in message news:62b4c4c1f7074@uwe...
I have a spreadsheet as a data source. The data in each field is
either a Y
or N. There could be more than one Yes for a record.

A B C D E
1 Y N N N N
2 N Y N N N
3 Y Y N N N
etc

In my merge document, I want to place an embedded object in a table
cell depending on the criteria in the spreadsheet: { If {
mergefield A } = "Y" "
{EMBED Word.Picture.8 }" }

In addition, I would also like to place a different embedded object
if A=N and B=Y in the same cell in merge document.
If A=Y and B=Y, then I would like to place an embedded object in the
first cell in the merge document and a new embedded object in
another cell in the
merge document.

I hope there's some programming language using the "if then"
statements. Thanks