Insert a file into a merge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kim - 18 Jul 2005 16:16 GMT

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

Reply to this Message

Doug Robbins - 18 Jul 2005 17:13 GMT

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/cindymeister/MergFram.htm

Signature

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

> Hi
>
[quoted text clipped - 13 lines]
> Can anyone please suggest a solution?
> Thank You

Reply to this Message