How to Mail Merge Word Labels With Variable Image Inserts per Row

You need to print labels where each row contains a different image — a product photo, a headshot, or a logo — alongside text fields like name and address. Standard mail merge in Word can pull text from an Excel or Access data source, but it does not natively swap images per record inside a table cell. This article explains how to set up a mail merge label template that inserts a different image for each row using the INCLUDEPICTURE field combined with your data source. You will learn the exact field syntax, how to prepare your image files, and how to handle broken links after merging.

How the INCLUDEPICTURE Field Works in a Mail Merge

Word’s mail merge engine was designed primarily for text. When you insert a Merge Field into a label template, Word places the value from your data source into that cell. For images, however, you cannot simply insert a Merge Field that points to a picture file — Word will show the file path as plain text, not the image itself.

The solution is to use the INCLUDEPICTURE field. This field accepts a file path as its argument and renders the image at that path. To make the path change per label row, you nest a MERGEFIELD inside the INCLUDEPICTURE field. When Word performs the merge, it builds a path like C:\Images\Photo_001.jpg for each record, and INCLUDEPICTURE attempts to load that file.

There are two critical prerequisites. First, your data source — typically an Excel worksheet — must contain a column that holds the full file path or a file name. If you store only the file name, you need to hardcode the folder path in the INCLUDEPICTURE field. Second, every image file must exist at the specified location before you run the merge. Missing files cause Word to display a broken-link placeholder.

What Happens During the Merge Preview

When you click Preview Results in the Mail Merge wizard, Word does not actually load the images. It shows the field codes. Only after you complete the merge and use the keyboard shortcut to update fields do the images appear. This behavior often confuses first-time users, but it is by design — INCLUDEPICTURE fields are not rendered until you force a field update.

Steps to Set Up a Mail Merge Label Template With Variable Images

These steps assume you have a data source ready. Your data source must include at least one column named ImagePath or Photo that contains either the full path or the file name of each image. For this example, the column Photo contains file names such as Photo_001.jpg and all images are stored in C:\LabelImages\.

1. Open Word and start the Mail Merge wizard for labels
   Go to Mailings > Start Mail Merge > Labels. Select the label vendor and product number that matches your label sheets. Word creates a table with cells that match your label dimensions. Click OK.
2. Select your data source
   Click Select Recipients > Use an Existing List. Browse to your Excel file or Access database and choose the sheet or table that contains the records. If your data source contains header rows, make sure the First row of data contains column headers check box is selected.
3. Insert the text merge fields
   Click inside the first label cell. Insert the text fields you need — for example, First Name, Last Name, and Address. Use the Mailings tab > Insert Merge Field to add each one. Format the text as you want it to appear on every label.
4. Insert the INCLUDEPICTURE field for the image
   Place your cursor where the image should appear in the first label cell. Press Ctrl + F9 to insert a pair of field braces { }. Inside the braces, type the following field code exactly:
   { INCLUDEPICTURE "C:\\LabelImages\\{ MERGEFIELD Photo }" \ MERGEFORMAT }
   Replace C:\LabelImages\ with your actual folder path. Replace Photo with the name of the column in your data source that holds the file names. Use double backslashes in the path.
5. Copy the field to all other label cells
   Select the entire first label cell including the field codes and text. Click Mailings > Update Labels. Word copies the content of the first cell to every cell in the label table. Each cell will contain the same field codes but will reference the corresponding record’s data during the merge.
6. Run the merge to a new document
   Click Finish & Merge > Edit Individual Documents. Choose All records and click OK. Word generates a new document with one page per label sheet. At this point, the image fields show error placeholders — this is expected.
7. Update all INCLUDEPICTURE fields to show the images
   Press Ctrl + A to select the entire merged document. Then press F9. Word refreshes every INCLUDEPICTURE field, loads each image from the specified path, and displays it in the label cells. This step is mandatory — without it, you will not see the actual images.
8. Save the merged document as a PDF or print it
   Once the images appear, review a few labels to confirm that the correct image appears next to the correct text. Save the file or send it to the printer. If you save as a Word document, the images remain embedded.

Common Issues With Variable Image Mail Merge Labels

Word Shows Field Codes Instead of Images After Merge

This is the most frequent problem. After you run Finish & Merge, the label cells display { INCLUDEPICTURE ... } or a broken image icon. The fix is to select the entire document with Ctrl + A and press F9. If the images still do not appear, check whether the file paths in your data source are correct. A single typo in a file name or folder path causes that specific label to fail.

All Labels Show the Same Image

This happens when the MERGEFIELD argument inside INCLUDEPICTURE is not referencing the correct column, or when you hardcoded a static file name instead of a field. Edit the field code in the first label cell by right-clicking and choosing Toggle Field Codes. Verify that the inner MERGEFIELD name matches the column header in your data source exactly. After correcting, run the merge again.

Image File Paths Are Too Long or Contain Spaces

Windows has a maximum path length of 260 characters. If your folder structure is deep or your file names are long, INCLUDEPICTURE may fail silently. Move the image folder closer to the drive root, for example C:\Images\. If file names contain spaces, wrap the entire path argument in double quotation marks inside the field code — the example in step 4 already does this.

Images Are Missing After Moving the Folder

The INCLUDEPICTURE field stores the absolute path that was valid at merge time. If you move the image folder to a different location after merging, the images break. Either move the folder back, or update the field codes in the merged document to point to the new location. To update, press Alt + F9 to show all field codes, edit the path manually, then press F9 to refresh.

Item	Standard Mail Merge (Text Only)	Mail Merge With INCLUDEPICTURE
Data source requirement	Any column with text values	Must include a column with file paths or file names
Image file location	Not applicable	All images must be in a single folder accessible by the merge document
Field type used	MERGEFIELD	INCLUDEPICTURE with nested MERGEFIELD
Post-merge step required	None	Ctrl + A then F9 to refresh all image fields
Image appears in Preview Results	Not applicable	No — images only appear after final merge and field update
Suitable for one-off labels	Yes	Yes, but requires careful file preparation

You can now generate label sheets where each row contains a unique image pulled from your data source. To speed up future merges, store all images in a flat folder with short file names and no special characters. If you frequently merge labels with variable images, consider using a VBA macro that automates the INCLUDEPICTURE field insertion and the post-merge F9 refresh.