Hi

I have a mail merege document pulling info from excel list.
At one point I need to insert text and pictures, which are in word docs.
I have field with an ID for one of four options. each option relates to the
word document.
So I need to set up a merge field that behaves like this:
If excel code field = aa1 then insert file aaa
If excel code field = bb1 then insert file bbb
If excel code field = cc1 then insert file ccc
and so on.
I have tried the If then field but there are not enough options and the text
box does not allow for pictures.
Can anyone please suggest a solution?
Thank You

You need to use a "nested" If...then...else construction,

{ If excelcodefield = aa1 dothis { if excelcodefield = bb1 dothat
dosomethingelse } }

For the pictures bit, 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



--
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
"kim" wrote in message
news
Hi

I have a mail merege document pulling info from excel list.
At one point I need to insert text and pictures, which are in word docs.
I have field with an ID for one of four options. each option relates to
the
word document.
So I need to set up a merge field that behaves like this:
If excel code field = aa1 then insert file aaa
If excel code field = bb1 then insert file bbb
If excel code field = cc1 then insert file ccc
and so on.
I have tried the If then field but there are not enough options and the
text
box does not allow for pictures.
Can anyone please suggest a solution?
Thank You