locked
Mail Merge currency field is summing RRS feed

  • Question

  • I am doing a mail merge and adding in the switch for the currency field. I have multiple values for the field. Before putting in the switch all values displayed (but not with the $). Once I add in the switch it sums them all together. Any ideas?
    Thursday, February 14, 2019 6:33 PM

All replies

  • A single field should only contain a single value. Adding a switch to a field containing multiple values will cause them to be processed mathematically (which gives bizarre results with dates); it cannot simply add formatting to all the expressions in the field.

    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Proposed as answer by Charles Kenyon Friday, February 15, 2019 3:49 AM
    Thursday, February 14, 2019 9:10 PM