mail merge calculations

macropod · #2 11-04-2017, 06:04 AM

For the SubTotal:
{QUOTE{=«Work.SubTotal»+«Labouramount»+«Sundriesam ount»}}
For the VAT:
{QUOTE{=(«Work.SubTotal»+«Labouramount»+«Sundriesa mount»)*.1}}

Note: The field brace pairs (i.e. '{ }') for the above examples 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. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I mail merge records into table columns with more than one merge field?	tech123	Mail Merge	1	04-26-2017 07:13 PM
Mail Merge is Deleting objects in my header and footer during the merge	bgranzow	Mail Merge	9	06-05-2015 05:03 AM
Is data merge and mail merge the same thing?	ikearns	Mail Merge	1	09-12-2014 03:53 AM
Mail merge how to link mail merge field value to a column heading	dsummers	Mail Merge	1	05-08-2014 02:59 PM
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM