Fix Excel IMAGE QR Codes in Word Mail Merge
Question details
The user needs to understand Excel IMAGE function availability and create reliable QR-code labels through Word mail merge.
- Product
- Microsoft Excel and Microsoft Word
- Device & OS
- not provided
- Scenario
- An Excel worksheet contains QR codes generated with the IMAGE function, and the user wants to merge those codes into Word labels.
- Observed behavior
- The IMAGE function may work in Excel for the web but be unavailable in an older desktop build, while Word mail merge may not reliably insert Excel IMAGE formula results as inline pictures.
Check the Excel installation's license, update channel, and build under File > Account. Prepare a small test dataset with one QR-code record and a saved image path before attempting a full label merge.
Update Microsoft 365 and confirm IMAGE function support
Use this option when IMAGE works in Excel for the web but is missing or unavailable in the desktop application.
Excel IMAGE support depends on the Microsoft 365 build, license, and update channel. Older perpetual editions or semiannual installations may not include the function.
In desktop Excel, select File, then Account to view the installed product, license, update channel, and version information.
Under Product Information, select Update Options > Update Now and allow Microsoft 365 to finish updating.
Open a blank worksheet and enter a test formula such as =IMAGE("https://example.com/qr.png"). If the function is still unavailable, confirm that the Microsoft 365 license and update channel support it.
Use saved QR-code image files for the Word merge
Use this workflow when Word must produce dependable labels and cannot merge Excel IMAGE formula results as inline pictures.
Create compatible spreadsheets and documents with WPS Office
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface and strong compatibility for common Excel and Word workflows. It supports XLSX and DOCX files, helping you migrate spreadsheet data and document-based label projects without changing your everyday file formats.
- 1. Open the source workbook: Install WPS Office, open WPS Spreadsheets, and select Open to load the existing XLSX data source.
- 2. Prepare QR-code data: Review the QR-code URLs or saved image paths in the spreadsheet and confirm that each record has a unique value.
- 3. Create the document workflow: Open WPS Writer to prepare the compatible DOCX label document, then use the spreadsheet data and saved QR images to complete the label layout.

Frequently Asked Questions
Why does Excel IMAGE work online but not in desktop Excel?
The desktop application may use an older Microsoft 365 build, an unsupported perpetual license, or a restricted update channel. Check File > Account and select Update Options > Update Now, then verify that the license supports IMAGE.
Can Word mail merge insert QR codes created with Excel IMAGE?
Word does not reliably merge Excel IMAGE formula results as inline pictures. For dependable output, save each QR code as an image file and merge its path with an image or INCLUDEPICTURE field.
How should QR-code images be named for a mail merge?
Use unique, stable filenames such as customer-001.png and store them in a folder that will remain available during the merge. Put the matching path or filename in a dedicated Excel column.
Why are QR codes missing or unchanged in the merged Word document?
The image field may need to be updated after the merge. In Word, select the document content with Ctrl+A and press F9, then preview the results and check that every image path is valid.
Should I print all labels immediately after setting up the merge?
No. Merge a small sample first and scan several QR codes. This verifies image paths, field updates, sizing, and readability before the complete label batch is printed.




