Conditional Mail Merge w/ Image Problem

Question

I am trying to set up a conditional Mail Merge where if the field Corn_Member = Yes an image will be inserted and if the merge field is blank no image will be inserted. Here is the code I have inserted but I cannot get the image to show up. I have tried merging everything and then in the new document pressing CTRL + A then F9 and still get nothing. What am I doing wrong?

{  IF { MERGEFIELD Corn_Member } = "Yes" { INCLUDEPICTURE "{ IF TRUE "Z:\Communications\Logos\Current Logo\color_logo_nowords.jpg"}" \d } ""  }

Answer 1

Hi Theresa,

It is possible that the formula you are using is not complete and is missing something. That being said, you can use the information found on the links below as your guidelines in doing a conditional Mail Merge.

• Set the rules for a mail merge
• Add formulas and conditional statements
• Advanced mail merge

Hope this information helps you. In case you need further assistance, don't hesitate to post back.

Answer 2

Try using just

{ INCLUDEPICTURE "{ IF TRUE "Z:\Communications\Logos\Current Logo\color_logo_nowords.jpg"}" \d }

You must use CTRL+F9 for each pair of field delimiters.

If that works, when using it inside the If...then...Else field construction, it may be an issue of the field needing to be updated.

Answer 3

I copied that exact field code in and it still isn't working. I'm wondering if maybe the location I have for my photo is incorrect. I sort of cobbled that together based on copy and paste.

How do I go about getting the exact location for the photo or is there a better way to insert the picture instead of pulling it from my computer server?

Answer 4

The field construction should be:

{  IF { MERGEFIELD Corn_Member } = "Yes" { INCLUDEPICTURE "{ IF TRUE "Z:\Communications\Logos\Current Logo\color_logo_nowords.jpg"}" \d } ""  }

To insert each pair of field delimiters, CTRL+F9 must be used.