How to Fix Mail Merge Images and Hyperlinks Repeating the First Record
Question details
The user needs to send personalized emails using a mail merge where each recipient receives a unique dynamic image and hyperlink.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Running a mail merge to send direct emails containing variable web images and hyperlinks based on a spreadsheet data source.
- Observed behavior
- When merging to individual documents, the images and hyperlinks refresh correctly. However, when merging directly to email delivery, every message incorrectly uses the first recipient's image and hyperlink.
Verify that your Excel data source is formatted correctly, with all field names in the very first row and the data worksheet positioned as the first sheet in the workbook. Save and close the Excel file before starting the merge.
Use a Third-Party Mail Merge Add-in
Standard Word email merging struggles to refresh INCLUDEPICTURE fields per recipient. Using a dedicated add-in like Merge Tools bypasses this limitation.
Microsoft Word's native 'Merge to Email' function caches dynamic fields like INCLUDEPICTURE and complex hyperlinks, causing it to send the first record's data to all subsequent recipients. To correctly generate dynamic graphics and links for each email, you should utilize an advanced mail merge add-in designed for attachments and dynamic content.
Download and install a trusted mail merge add-in, such as the Merge Tools add-in featuring the 'Merge with Attachments' facility.
Open your Excel data file. Ensure that all column headers are strictly in row 1 and that the sheet containing your data is the first active tab in the workbook.
Open your Word document, navigate to the newly installed add-in tab (e.g., Merge Tools), and select the option for 'Merge to Email Messages'. Follow the add-in prompts to map your dynamic fields.

Merge to Individual Documents and Force Update Fields
If you cannot install third-party add-ins, use a manual workaround by merging to a new document and force-updating all fields before sending.
Try WPS Office for Seamless Document Management
If you frequently encounter persistent limitations or complex workarounds in Microsoft Word's advanced features, consider switching to WPS Office. It provides a highly compatible, feature-rich, and user-friendly alternative for your document processing workflows.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the software: Run the installer and follow the on-screen instructions to set up the office suite on your computer.
- 3. Open your files directly: Launch WPS Writer and open your existing .docx templates and .xlsx data sources without needing to convert them.

Frequently Asked Questions
Why do images repeat the first record during a Word mail merge to email?
When merging directly to email delivery, Microsoft Word's background processing caches dynamic fields like INCLUDEPICTURE and complex hyperlinks to save resources. As a result, it fails to trigger an update per recipient, applying the first record's cached data to the entire batch.
Can I fix the hyperlink mail merge issue without downloading third-party add-ins?
Yes, you can bypass the direct email merge by clicking 'Finish & Merge' and selecting 'Edit Individual Documents'. Once the new document generates, press 'Ctrl + A' to select all text and 'F9' to manually force the fields to update. However, you will then have to email each page separately.
How should I format my Excel data for a successful mail merge?
For optimal compatibility, ensure that the worksheet containing your recipient data is the very first tab in your Excel workbook. Additionally, place all column headers (field names) strictly in the first row, removing any blank rows or merged title headers above them.
Does WPS Office support Mail Merge functionality?
Yes, WPS Writer includes a comprehensive Mail Merge feature located under the References tab. It allows you to seamlessly connect spreadsheets to document templates to generate bulk letters, labels, and emails.




