Office Settings & Configuration

Fix the Data Link Properties Dialog in Word Mail Merge

Phi Hung VoPhi Hung Vo Nov 13, 2026 869 views

Question details

The user needs to stop the Data Link Properties dialog from appearing when standard users open Microsoft Word mail merge main documents that have an attached data source, while administrators can open the same documents normally.

Fix the Data Link Properties Dialog in Word Mail Merge
Product
Microsoft Word Mail Merge
Device & OS
not provided
Scenario
In an Office Home and Business 2013 environment recently affected by a cryptovirus incident, standard users need to open mail merge documents for normal work.
Observed behavior
Opening the mail merge document first shows a Word error, then a DCOM timeout, and finally the Data Link Properties dialog. Administrators do not see the dialog, and the MergeSQLMessageEliminator add-in returned a compilation error.
Before you start

Before making changes, confirm that the document is a mail merge main document with an attached data source and test the behavior under a standard Windows user account. Note the Word version and whether any Word error or DCOM timeout appears before the dialog, because these details determine which fix applies.

Solution 1Recommended

Suppress the Prompt by Adding the Word SQLSecurityCheck Registry Value

Use this when you need to keep the existing Word mail merge document and stop the Data Link Properties dialog for standard users without replacing the data source.

This is the Microsoft-documented Word option for controlling the mail merge SQL/data source security prompt. It changes only the current user's Word behavior, so apply it under each affected Windows user profile or deploy the value through Group Policy.

1
Close all Word windows

Save and close any open Word documents, then exit Microsoft Word so the registry change is read when Word restarts.

2
Open Registry Editor

Press Windows + R, type regedit, and click OK. If prompted by User Account Control, click Yes.

3
Locate the Word Options key

Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options. For other Office versions, replace 15.0 with the installed version number.

4
Create the SQLSecurityCheck value

Right-click the Options key, choose New > DWORD (32-bit) Value, name it SQLSecurityCheck, double-click it, and set Value data to 0.

5
Restart Word and test

Open Word as the affected standard user, open the mail merge main document, and confirm that the Data Link Properties dialog no longer appears. If the DCOM timeout error persists, investigate the system or network issue separately.

Suppress the Prompt by Adding the Word SQLSecurityCheck Registry Value
Prompt suppressed: After this change, Word should open the attached mail merge data source without showing the Data Link Properties dialog for the affected user.
Free Microsoft Office alternative

Use WPS Writer for Mail Merge Without the Word Data Link Dialog Issue

WPS Office is a free, lightweight Microsoft Office alternative that opens .docx mail merge documents and lets you connect to spreadsheets or CSV data from a familiar ribbon interface. It is a practical way to continue mail merge work when Word repeatedly shows the Data Link Properties dialog or DCOM errors.

  1. 1. Download WPS Office: Visit the WPS Office download page, download the installer, and run it on the computer where you need to continue mail merge work.
  2. 2. Open the Word mail merge document in WPS Writer: Launch WPS Writer, click Menu > Open, select the .docx mail merge main document, and confirm that the document appears in the familiar ribbon layout.
  3. 3. Set up the recipient list in WPS Writer: Click the Mailings tab, then click Recipients to attach your Excel .xlsx, CSV, or another data source, and finish the merge without the Word Data Link Properties prompt.
Mail merge in WPS Writer uses a simple recipient-list workflow that avoids the recurring Word Data Link Properties-style SQL prompt.Opens, edits, and saves .docx Word documents and .xlsx Excel data sources with high format compatibility.Free and lightweight, so it can be deployed quickly on systems where the Office 2013 mail merge prompts are disruptive.Familiar ribbon interface reduces training and lets users switch from Word with minimal disruption.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Data Link Properties dialog appear only for standard users and not administrators?

This usually happens because the mail merge main document has an attached OLE DB or SQL data source, and only the standard user profile lacks the Word option or registry value that controls the prompt. Apply the SQLSecurityCheck registry value under the affected user profile or use the recommended Word procedure.

Can I use WPS Office to open my Word mail merge document if the dialog keeps appearing?

Yes. WPS Writer can open .docx mail merge main documents and connect to a new or existing recipient list. In WPS Writer, use the Mailings tab > Recipients to select a spreadsheet or CSV source without the Word Data Link Properties prompt.

The MergeSQLMessageEliminator add-in gives a compilation error. Should I keep using it?

If it returns a VBA compilation error in Office Home and Business 2013, it may not be compatible with the current installation. Disable the add-in in File > Options > Add-ins > COM Add-ins and use the SQLSecurityCheck registry setting instead.

What should I check if the Word error or DCOM timeout appears before the Data Link Properties dialog?

First verify whether the prompt is tied to a specific standard user profile. If Word errors or DCOM timeouts continue after the registry fix, investigate Windows permissions, Office configuration, and any remaining issues from the cryptovirus incident, and contact Microsoft support if necessary.