Template Issues

How to Use Read-Only Word Templates for Editable Mail Merge

Olivia Miller Oct 23, 2026 868 views

Question details

The user wants to perform a mail merge using a protected, read-only Word template and an Excel data source without altering the original file.

How to Use Read-Only Word Templates for Editable Mail Merge

Product: Word
Device & OS: not provided
Scenario: Setting up an editable mail merge in Word using Excel data, based on an existing template that has been marked as read-only.
Observed behavior: Read-only Word files open in View mode by default, preventing users from directly editing the document or executing a mail merge from it.

Before you start

Ensure you have your Excel data source prepared and know the exact file path of your protected Word template.

Solution 1Recommended

Create a New Document from the Templates Folder

By storing the read-only file in your default templates folder, you can generate a fresh, editable document based on the protected original.

Opening a read-only document directly forces it into View mode. Using Word's built-in template feature creates a completely new, editable copy while keeping the original safe.

Store the template file

Move or copy your read-only Word document into the default 'User Templates' or 'Workgroup Templates' folder on your computer.

Create a new document

Open Microsoft Word, click on the 'File' menu, and select 'New'.

Select your custom template

Click on the 'Personal', 'Custom', or specific subfolder tab in the New Document dialog to locate your template. Double-click it to open an editable copy.

Execute the mail merge

Navigate to the 'Mailings' tab, link your Excel data source, insert your merge fields, and complete the mail merge process as usual.

Create a New Document from the Templates Folder

Quick Access Tip: You can right-click the ribbon and choose 'Customize Quick Access Toolbar' to add the 'New Document or Template' command for faster access in the future.

Solution 2

Utilize Windows File Attributes (Microsoft 365)

If you are using Microsoft 365 Apps for enterprise, a document strictly using the Windows read-only attribute can still process mail merges.

Efficient Mail Merge Solution

Perform Mail Merges Easily with WPS Office

WPS Writer offers an intuitive and powerful Mail Merge feature that is fully compatible with Microsoft Word templates and Excel data sources. It simplifies the process of generating bulk letters, labels, and emails without struggling through complex read-only restrictions.

1. Open your template: Launch WPS Writer and open your template document. If it is read-only, simply click 'Save As' to create a quick editable working copy.
2. Import Excel data: Go to the 'Mailings' tab, click on 'Open Data Source', and select your prepared Excel spreadsheet.
3. Insert fields: Use the 'Insert Merge Field' button to place the necessary data points into your document.
4. Generate documents: Click 'Merge to New Document' to output all your personalized files at once.

Fully compatible with Microsoft Word (.docx) templates and Excel (.xlsx) data filesIntuitive Mail Merge wizard for fast and accurate document generationEasily handle read-only files by saving copies with a single clickFree, lightweight, and user-friendly interface for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Word template open in View mode instead of Edit mode?

When a document is saved with read-only protection or strict editing restrictions, Word defaults to View mode to prevent accidental overwrites. To bypass this and create an editable version, you must use the 'File > New' method to generate a fresh copy based on that template.

Where is the User Templates folder located on Windows?

By default, the User Templates folder is typically located at 'C:\Users\[YourUsername]\Documents\Custom Office Templates' or 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Templates'. Saving your documents here allows them to appear under the 'Personal' or 'Custom' tab in the File > New menu.

Can I perform a mail merge on a password-protected document?

If the document is password-protected against editing, you generally cannot link a data source or insert merge fields without entering the password first. You will need to unlock the document, perform the merge, and then reapply the protection if necessary.

Document & File Issues