Office Settings & Configuration

Fix Word Mail Merge Currency Field Syntax Errors

John Wilson Oct 23, 2026 868 views

Question details

The user encounters syntax errors in Word mail merge fields used to convert dollar amounts into words, which occurs on one computer but works perfectly on another.

How to Fix Word Mail Merge Currency Field Syntax Errors

Product: Microsoft Word
Device & OS: Windows
Scenario: Generating a mail merge document that uses nested field codes to format numeric currency values into written words.
Observed behavior: Instead of displaying the formatted currency text, the document displays a field code syntax error on specific machines due to misinterpreting nested field parameters.

Before you start

Close any active Microsoft Word documents and ensure you have administrative access to your Windows Control Panel, as you will need to modify system-wide regional settings.

Solution 1Recommended

Adjust the Windows Regional List Separator

Fix the syntax error by changing the system's list separator character back to a comma, ensuring Word correctly parses the arguments inside nested field codes.

Microsoft Word relies on the Windows operating system's regional settings to interpret complex, nested field codes. If the system's list separator is set to a pipe character (|) or semicolon (;) instead of a standard comma (,), Word will fail to parse the currency formatting arguments, resulting in a syntax error.

Open the Control Panel

Click the Windows Start menu, type "Control Panel" in the search bar, and press Enter to launch the application.

Navigate to Region Settings

Click on "Clock and Region", then select "Region" to open the regional settings dialog box.

Access Additional Settings

At the bottom of the Formats tab in the Region window, click the "Additional settings..." button.

Change the List Separator

Under the "Numbers" tab, locate the "List separator" field. Delete the existing character (such as a pipe |) and type a standard comma (,). Click Apply, then OK.

Update Mail Merge Fields

Reopen your document in Microsoft Word, highlight your mail merge fields, and press F9 to update them. The syntax error should now be resolved.

Adjust the Windows Regional List Separator

System-wide Impact: Changing the list separator to a comma will also normalize how CSV files are exported in Excel and how formulas are separated.

Solution 2

Use VBA Macros to Simplify Field Codes

If changing system settings isn't an option, you can use specialized macros to convert text representations of currency fields into working field codes.

Effortless Mail Merge

Execute Mail Merges Smoothly with WPS Office

Avoid complicated nested field syntax errors and regional setting conflicts by using WPS Writer for your mail merge tasks. WPS Office features an intuitive, highly compatible Mail Merge wizard that effortlessly handles data sources and currency formatting.

1. Open WPS Writer: Launch WPS Writer and open the main document template you wish to use for your mail merge.
2. Access the Mail Merge Tool: Navigate to the "References" tab on the top ribbon and click on "Mail Merge" to activate the toolbar.
3. Import Your Data Source: Click "Open Data Source" and select the spreadsheet containing your currency values and recipient data.
4. Insert Currency Fields: Place your cursor where the currency needs to appear, click "Insert Merge Field", and select the corresponding column from your data.
5. Complete the Merge: Click "Merge to New Document" to instantly generate your finalized, properly formatted letters without encountering nested code syntax errors.

Seamless compatibility with Microsoft Word (.docx) formats and Excel data sourcesIntuitive Mail Merge wizard with visual field mappingRobust data handling without relying on complex system-level list separatorsLightweight, fast, and free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why does my mail merge field show a syntax error on only one computer?

This usually occurs because the two computers have different regional settings in Windows. If the list separator on one machine is set to a pipe (|) or semicolon (;) instead of a comma (,), Word's field code engine cannot properly parse nested formatting arguments.

Can I format numbers as currency directly in a Word mail merge?

Yes, you can apply a numeric picture switch directly to your merge field. By toggling field codes (Alt + F9) and adding '\# "$#,##0.00"' to the end of the merge field name, the raw number will automatically display as standard currency.

How do I view and edit the raw field codes in my Word document?

You can toggle the display between the final field results and the raw field codes by pressing Alt + F9 on your keyboard. This allows you to inspect the syntax, brackets, and switches to make manual corrections.

Does the Windows list separator setting affect other applications?

Yes. The Windows list separator setting dictates how function arguments are separated in Microsoft Excel formulas and how columns are divided when exporting data to CSV (Comma Separated Values) files across the entire operating system.

Office App Problems