Fix the Data Link Properties Dialog in Word Mail Merge
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.

- 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 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.
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.
Save and close any open Word documents, then exit Microsoft Word so the registry change is read when Word restarts.
Press Windows + R, type regedit, and click OK. If prompted by User Account Control, click Yes.
Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options. For other Office versions, replace 15.0 with the installed version number.
Right-click the Options key, choose New > DWORD (32-bit) Value, name it SQLSecurityCheck, double-click it, and set Value data to 0.
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.

Use the MergeSQLMessageEliminator Add-in When the Manual Procedure Is Not Suitable
Use this if you cannot edit the registry or need Microsoft's add-in method for suppressing mail merge SQL prompts.
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. 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. 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. 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.

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.




