How to Insert and Resize Images in Word Mail Merge
Question details
The user needs to insert customer signature images from URLs into a Word mail merge without the images duplicating, appearing in the wrong location, or stretching to the full page width.

- Product
- Word Mail Merge
- Device & OS
- not provided
- Scenario
- Creating a mail merge using C# and SQL data to insert dynamic images, such as signatures, from URLs into a specific area of a document.
- Observed behavior
- Inserted images are duplicating, appearing in incorrect locations, or expanding to the full page width instead of fitting the designated merge field size.
Ensure you have your primary merge document, SQL data source, and valid image URLs ready. It is highly recommended to test the merge with a small sample data file and a non-confidential image first to verify formatting.
Use a One-Cell Table to Constrain Image Size
Placing your INCLUDEPICTURE or merge field inside a one-cell table with fixed dimensions prevents images from expanding to the full page width.
When inserting images via mail merge, the software typically brings them in at their original resolution. By encapsulating the merge field within a single table cell with locked dimensions, you force the image to adhere to the maximum allowed height and width.
Navigate to the exact location in your document where the signature should appear. Go to the Insert tab, select Table, and insert a 1x1 table.
Right-click the table and select Table Properties. Go to the Row and Column tabs to set the exact maximum height and width for the signature. In the Table Options, uncheck 'Automatically resize to fit contents'.
Place your cursor inside the table cell and insert your image merge field or INCLUDEPICTURE field. Configure the image settings to maintain its aspect ratio.
Run the mail merge with a sample data file to verify that the signatures remain confined to the table cell's dimensions and appear in the correct location.

Diagnose Duplication and Path Issues with Sample Data
If images are duplicating or failing to load, isolate the issue by creating a simplified test case to diagnose field placement or data source errors.
Easily Manage Mail Merge with WPS Writer
WPS Writer offers robust and user-friendly Mail Merge tools, making it easy to connect external data sources and insert dynamic fields. You can perfectly align and format your documents with precise table controls to easily handle signature images.
- 1. Open WPS Writer: Launch WPS Office and open your primary template document in WPS Writer.
- 2. Start Mail Merge: Navigate to the References tab on the top ribbon and click on Mail Merge to activate the toolset.
- 3. Connect Data Source: Click 'Open Data Source' and select your spreadsheet or database file containing the image URLs.
- 4. Insert Fields: Use 'Insert Merge Field' to place your data points into the fixed-size table cells and complete the merge.

Frequently Asked Questions
Why do my merged images expand to the full page width?
By default, document editors insert images at their original resolution. If the source image is large, it will expand to fill the page margins. Placing the merge field inside a fixed-size table with 'Automatically resize to fit contents' disabled prevents this expansion.
How do I fix duplicated images in my mail merge?
Duplicated images often occur if the merge field codes are incorrectly nested, copied by mistake, or if the data source contains duplicate rows. Press Alt + F9 to reveal all field codes in the document and manually remove any accidental duplicates.
Can I use web URLs for images in a Mail Merge?
Yes, you can use the INCLUDEPICTURE field combined with a merge field that dynamically pulls the URL from your database to insert web-hosted images during the merge process.
Why is the image not updating when I preview the merge?
Merge fields containing images sometimes require a manual refresh to display the correct graphic. Try pressing Ctrl + A to select the entire document, then press F9 to update all field codes.




