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