File Format & Compatibility

Fix Microsoft Word Not Remembering a Mail Merge Data Source

Tauseeq MagsiTauseeq Magsi Nov 13, 2026 868 views

Question details

The user needs Microsoft Word to retain the connection to a mail merge data source instead of asking for its location repeatedly.

Fix Microsoft Word Not Remembering a Mail Merge Data Source
Product
Microsoft Word; a data source possibly exported from FileMaker
Device & OS
not provided
Scenario
Opening or using a mail merge document linked to a data file named Untitled.mer.
Observed behavior
Word repeatedly asks for the location of Untitled.mer even after the user selects the source file.
Before you start

Locate Untitled.mer and confirm which application created it. Keep the source in a stable, accessible folder, and check that you can save changes to the Word mail merge document.

Solution 1Recommended

Save a correctly formatted data source and reconnect it in Word

Use this approach when Word repeatedly requests an exported or ambiguously named source such as Untitled.mer.

FileMaker can export merge data with a .mer extension, so the extension alone does not prove the file is invalid. Check how the file was created; changing its extension manually does not convert its contents.

Saving in the creating application's native format can help preserve the original data, but Word must be connected to a format it can actually read. If the native format is not supported by Word, export a compatible data file instead.

1
Check the source in its original application

Open the source in the application that created it. If it came from FileMaker, open the original database and inspect the records and field names intended for the merge.

2
Save or export with a descriptive filename

Use Save As or the application's equivalent to save the original data in its native format. If Word cannot read that format, use the application's Export command to create a supported source, such as an Excel workbook or CSV file. Give it a descriptive name, such as CustomerMailingList.xlsx, and save it in a folder where it will remain accessible. Do not simply rename Untitled.mer to .xlsx.

3
Reconnect the source in Word

Open the mail merge main document in desktop Word. Go to Mailings > Select Recipients > Use an Existing List, then select the properly saved or exported source. If prompted, choose the worksheet or table containing your recipient records.

4
Verify the records and save the merge document

Select Mailings > Edit Recipient List to check the recipients, then use Preview Results to verify the merge fields. Choose File > Save to store the updated connection in the main document. Close and reopen that document to check whether Word retains the source location.

Save a correctly formatted data source and reconnect it in Word
Keep the saved source path available: Moving or renaming the data file after reconnecting it can cause Word to request its location again. If you exported a new source, confirm that its field names still match the document's merge fields.
Free Microsoft Office alternative

Prepare Mailing Lists and Word Documents with WPS Office

WPS Office is a free, lightweight, easy-to-use alternative for working with mailing-list spreadsheets and Word documents. Its familiar interface and Microsoft Office format compatibility make migration straightforward, though it does not repair Word's saved mail merge connection.

Review recipient names, addresses, and column headers in WPS Spreadsheets.Work with Microsoft Excel .xlsx and Microsoft Word .docx files.Use a familiar Office-style interface with a lightweight desktop suite.Move existing documents and spreadsheets into WPS without manually retyping their contents.
microsoft office alternative - wps office

Frequently Asked Questions

Is a FileMaker .mer file automatically an invalid mail merge source?

No. FileMaker can generate .mer files through its merge export option. Check the export settings and file contents rather than assuming the extension is wrong. If Word cannot reliably read the file, export a supported format and reconnect it through Mailings > Select Recipients > Use an Existing List.

Can I rename Untitled.mer to Untitled.xlsx to fix the connection?

No. Renaming the extension does not convert the file into an Excel workbook. Use the creating application's Save As or Export command to produce the required format, then select that new file in Word.

Which document should I save after selecting the data source?

Save the mail merge main document—the document containing the merge fields—using File > Save after selecting the source. Saving only the data file or the finished merged output does not update the main document's connection.

Why does Word ask for the source again after I move it?

The saved connection may still point to the previous location. In the main document, go to Mailings > Select Recipients > Use an Existing List, select the file in its new location, and save the document again. Make sure the folder remains accessible when you reopen Word.

What should I check if the new source connects but the merge fields do not work?

Open Mailings > Edit Recipient List and confirm that you selected the correct worksheet or table. Check that the new source's column names match the fields used in the document, then use Mailings > Match Fields or replace affected fields through Insert Merge Field as needed.