Thread: Word Macro for inserting Multiple Pictures

Hi Ajay,

If you configure the Excel file correcly, you can do the lot via Word's mailmerge tool, without the need for code. In the Excel file, you'd need every employee's:
• ID
• Details (can be multiple columns)
• Picture name (eg Fred.jpg)
You'd the use a label merge in Word. The only tricky field to produce is for the pictures. For that you'd need a field coded like:
{IF {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"} \d} {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"} \d}}
where 'Image' represents the picture column's name in the Excel worksheet and, instead of 'C:\Users\My Document Path\Pictures\' you'd use the actual filepath for the pictures.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.

Once you've laid out the first label correctly, simply click the 'update labels' button to replicate the layout to all labels on the page. The mailmerge will then be ready to run.