Formatting Issues

How to Multiply Mail Merge Fields with Currency Formatting in Word

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to multiply a value within a Word mail merge field and format the resulting calculation with a specific currency symbol.

Product: Word
Device & OS: not provided
Scenario: Creating dynamic documents using Mail Merge where financial figures need to be multiplied (e.g., calculating tax or discounts) and formatted correctly as currency.
Observed behavior: Requires the correct formula syntax for multiplication and currency formatting, noting that third-party dynamic currency features (like Conga's Currency switch) often fail on calculated Word fields.

Before you start

Ensure your data source is properly linked to your Word document before editing merge field codes. Press Alt + F9 on your keyboard to toggle field codes and view the underlying formulas.

Solution 1Recommended

Use a Numeric Format Switch for the Calculated Mail Merge Field

Apply a calculation field combined with a numeric picture switch to multiply the merge field and format it as currency.

When multiplying values directly inside a Word document during a mail merge, you must nest the original merge field inside a formula field and append a numeric formatting switch (\#) to display the currency correctly.

Insert the outer calculation field

Press Ctrl + F9 on your keyboard to insert a set of blank field brackets { }. Type an equals sign '=' inside the brackets to indicate a calculation.

Insert the inner merge field

Place your cursor after the '=' sign and press Ctrl + F9 again to insert a second set of brackets. Inside these inner brackets, type your merge field identifier, such as 'MERGEFIELD OPPORTUNITY_AMOUNT'.

Add the multiplication factor

After the closing bracket of the inner merge field, type your multiplication formula, for example, '* 0.20' to multiply the amount by 20%.

Apply the currency format switch

Before the final closing bracket, add the numeric picture switch for currency: '\# $,0.00'. The complete formula should look like: { =({ MERGEFIELD OPPORTUNITY_AMOUNT } * 0.20) \# $,0.00 }.

Update and preview the field

Press Alt + F9 to hide the field codes, then select the field and press F9 to update the calculation. Click 'Preview Results' in the Mailings tab to verify the currency formatting.

Conga Currency Limitations: If you are using Conga to dynamically set currency cultures, be aware that its proprietary Currency switch typically does not function correctly on calculated Word merge fields. Relying on standard Word formatting switches is necessary when utilizing multiplication formulas.

Effortless Document Generation

Perform Mail Merge Calculations Easily in WPS Writer

WPS Writer provides robust Mail Merge capabilities, fully compatible with standard field codes and numeric formatting switches. Easily calculate values and apply specific currency formats in your mass mailings without any hassle.

1. Start Mail Merge: Open your document in WPS Writer and navigate to the 'References' or 'Mailings' tab to initialize the Mail Merge process.
2. Link Data Source: Click 'Open Data Source' and select your spreadsheet containing the financial data.
3. Insert Formula Field: Press Ctrl + F9 to insert a formula field and enter your calculation, such as { =({MERGEFIELD Amount} * 1.5) \# $,0.00 }.
4. Preview and Complete: Update the fields and click 'View Merged Data' to preview your calculated currency values before generating the final documents.

Fully compatible with Microsoft Word (.docx) formats and complex field codes.Seamlessly connect Excel spreadsheets as data sources for dynamic calculations.Lightweight software with an intuitive interface that makes editing field codes simple.Completely free to use for standard mail merge and document creation tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my mail merge calculation showing a syntax error?

Syntax errors usually occur if the field brackets '{ }' are typed manually using the keyboard instead of being generated correctly. You must press Ctrl+F9 to insert actual field boundaries.

How do I change the currency symbol in the mail merge format?

You can replace the dollar sign '$' in the format switch '\# $,0.00' with your desired currency symbol, such as '£' or '€'. For example: '\# £,0.00'.

Can I use Conga's dynamic Currency switch on a multiplied field?

Generally, no. Third-party dynamic currency switches (like Conga's) are often incompatible with calculated Word fields such as multiplication formulas. You will need to manually apply Word's native numeric format switches to control the output.

Document & File Issues