Conditional Image insertion based on Merge Data

[Kavo]

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!

[gmayor]

You need to complete the merge to a new document, and not rely on the preview. Mail merge of graphics is complicated - see http://www.gmayor.com/mail_merge_graphics.htm and http://www.gmayor.com/mail_merge_graphics_addin.htm

[Kavo]

Thank you! Worked like a charm!