Document Editing Problems

How to Mail Merge Pictures in Word from an Excel File

Camila Milosovich Sep 25, 2026 871 views

Question details

The user needs to include and display images dynamically from an Excel data source during a Word mail merge process.

How to Mail Merge Pictures in Word Using an Excel Data Source

Product: Microsoft Word, Microsoft Excel
Device & OS: not provided
Scenario: Setting up a document template that automatically loads different images for different records during a mail merge.
Observed behavior: Microsoft Word cannot merge or display images that are physically embedded directly inside the cells of an Excel workbook.

Before you start

Create a dedicated folder on your local drive to store both your Excel database and all the image files you plan to use in the mail merge to ensure your file paths remain stable.

Solution 1Recommended

Use Local File Paths in Excel Instead of Embedded Images

Since Word cannot extract embedded images from Excel cells, you must reference the local file paths of your saved images using field codes.

To successfully mail merge images, the picture files must be stored separately on your computer. Excel simply acts as a database providing Word with the exact text-based file paths to locate and pull those images into the final merged document.

Save your images locally

Place all the pictures you want to merge (e.g., .jpg or .png files) into a single folder on your computer.

Add file paths to your Excel file

Open your Excel workbook, create a new column named 'Image_Path', and paste the exact file path for each corresponding image (e.g., C:\\Images\\photo1.jpg). Save and close the workbook.

Insert the INCLUDEPICTURE field in Word

Open your Word document, press Ctrl+F9 to insert curly field brackets, and type INCLUDEPICTURE. It should look like { INCLUDEPICTURE }.

Nest the Merge Field

Inside the INCLUDEPICTURE field, insert a set of quotes, then press Ctrl+F9 again to insert the merge field for your image path. The final syntax should look like: { INCLUDEPICTURE "{ MERGEFIELD Image_Path }" \d }.

Update fields and complete the merge

Finish your mail merge by choosing 'Edit Individual Documents'. In the new merged document, press Ctrl+A to select all text, then press F9 to update the fields and display the images.

Use Local File Paths in Excel Instead of Embedded Images

Backslashes in File Paths: Depending on your version of Word, you may need to use double backslashes in your Excel file paths (e.g., C:\\Images\\pic.jpg) because a single backslash is often treated as an escape character.

WPS Office Mail Merge

Easily Perform Mail Merges with WPS Office

WPS Office provides a seamless and user-friendly Mail Merge feature in WPS Writer, allowing you to quickly generate customized batches of letters, labels, or emails using spreadsheet data.

1. Open WPS Writer: Launch WPS Writer, open your document template, and navigate to the 'References' tab on the top ribbon.
2. Connect your Data Source: Click on 'Mail Merge', then select 'Open Data Source' to import your prepared WPS Spreadsheet or Excel file containing your data and image file paths.
3. Insert Merge Fields: Use the 'Insert Merge Field' button to place your dynamic data exactly where you want it in the document.
4. Merge to Document: Click 'Merge to New Document' to automatically generate a new file containing all the populated records and fields.

Intuitive Mail Merge wizard to effortlessly connect spreadsheets to your document templates.Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) file formats.Free, lightweight, and easy-to-use office suite with a familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why won't Word mail merge images that are copy-pasted into Excel cells?

Word's mail merge engine reads textual data from the Excel spreadsheet. It cannot process binary image objects embedded directly inside the spreadsheet cells, so it requires a text-based file path to locate the image on your hard drive.

Do I need to use double backslashes in my Excel image file paths?

Yes, in many older and current versions of Word, a single backslash is treated as an escape character in field codes. Using double backslashes ensures that the file path is read correctly by the INCLUDEPICTURE field.

How do I make the images appear after finishing the mail merge?

After merging to a new document, the image fields often do not update automatically. You must select the entire document by pressing Ctrl+A, and then press F9 on your keyboard to force Word to update the field codes and display the correct images.

Can I use relative paths for my mail merge images?

Yes, but it is much more complex to set up. It is generally recommended to keep the Word template, Excel database, and images in the same folder, but using absolute paths (the full path from the drive letter) prevents most image-loading errors.

Document & File Issues