Conditional Image insertion based on Merge Data

Question

Hello, all. I am trying to insert a logo into a mail merge document based on the list ID that the data originated from.

Specifically, I have 3 data sources that were combined into one and once that list is processed and returned with data from all 3 lists, the list id tells me which list the data came from, and therefore, which logo should be inserted in the merged document.

The original CSV file does not contain the logo or image link. These are being stored on the PC and I want to pull them in based on the list ID in the CSV file.

For this action, I am using 

{INCLUDEPICTURE "{IF TRUE "C:\Users\kara\Documents\My Circulation\Renewals\{Mergefield LIST_ID}.png"}" \d }

Where the images are named according to the list id, ie. 1882.png.

When I go to preview my results, an image placeholder appears and tell me that it cannot find the file. What am I doing wrong? THANK YOU!

Answer 1

After a lot of tweaking, I finally got this to work. Thank you for your assistance!

Answer 2

Thank you for your help. I copied and pasted the path, as directed, and my path is correct. I also tried the construction above, and got the same result as when I tried it with what I posted.

The images are:

1886.png

792.png

2012.png

The path is: C:\Users\kara\Documents\My Circulation\Renewals

The construction used:

{IF {INCLUDEPICTURE {IF TRUE "C:\Users\kara\Documents\My Circulation\Renewals\{Mergefield LIST_ID}.png"} \d} {INCLUDEPICTURE {IF TRUE "C:\Users\kara\Documents\My Circulation\Renewals\{Mergefield LIST_ID}.png"} \d} }

Answer 3

Try using the following construction

{IF {INCLUDEPICTURE {IF TRUE "C:\Users\kara\Documents\My Circulation\Renewals\{Mergefield LIST_ID}.png"} \d} {INCLUDEPICTURE {IF TRUE "C:\Users\kara\Documents\My Circulation\Renewals\{Mergefield LIST_ID}.png"} \d}}

Another thing to check, in File Explorer, go to the Renewals folder and right click on the Address Bar and select "Copy address as text" and paste that into a document and compare it with the path in the field construction (It will of course not have the double field separators, but otherwise, it will need to be identical.

Answer 4

Yes. The images are named  972.png, 2012.png and 1774.png. The list id field has those same numbers. Minus the .png

Answer 5

Does the «LIST_ID» mergefield contain the filename (without the extension) of the graphics?  It will need to be an exact match.