Hi there



This is my first post here. I uses forums for MS Access and Salesforce a lot but word I use to a certain level but this is far higher than my ability range. I'm not even sure its possible.

I need to create a formula which subtracts one mail-merge tag from another. Please if you know how I could possibly do this I would be most grateful. I use OSX but have access to a PC with Office professional also.

I have attached the word doc with the space where I need the formula to go. The mail-merge tags above this all work great. My data source comes from a system called Conga which is a 3rd party app used in salesforce. Templates for it are made is MS Word. Is it possible to do this formula here?


Any help much appreciated!

Attached Files

Meals letter 2016 revised (6).docx (26.0 KB, 12 views)

You should be able to do that with a simple field formula, encoded as:
{QUOTE {=B2-B4 \# "$,0.00"}}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues.

To see how to do a wide range of math calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party

To see how to do a wide range of date calculations in Word, check out my Microsoft Word Date Calculation Tutorial, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled ''. Do read the document's introductory material.

You'd also do well to check out my Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
or at:
http://windowssecrets.com/forums/sho...ips-amp-Tricks
That said, when you're using a third-party product, what you can achieve is often limited by that product's capabilities.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

OK this is amazing thanks so much! This has worked it seems!