Hi there

I'm currently looking at doing some mailmerge calculations. I want to get
some examples of some of the syntax involved, for instance, division,
multiplication, and formatting the results properly on screen. Here's an
example:-

{={ MERGEFIELD CourseBookingCostByStatus_SumTuitionCost \* MERGEFORMAT} /
{MERGEFIELD CourseBooking_NumberofStudents } \# "£#,##0.00 } }

For instance, i'm trying to get word to divide the total cost of a training
course by the number of students enrolled - yet when the calcuation is
performed, it shows {= 32456.4300 / 3}, instead of the actual result.

Can someone help? Just think i need some syntax examples to follow..

many thanks

Ol

You have to insert all the field boundaries with CTRL+F9. The syntax then is

{=({ MERGEFIELD CourseBookingCostByStatus_SumTuitionCost} / {MERGEFIELD
CourseBooking_NumberofStudents }) \# "£,0.00 } }

Note too that your data fieldnames are excessively long which will lead to
errors. Restrict fieldnames to 10 characters if possible.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Oly wrote:
Hi there

I'm currently looking at doing some mailmerge calculations. I want
to get some examples of some of the syntax involved, for instance,
division, multiplication, and formatting the results properly on
screen. Here's an example:-

{={ MERGEFIELD CourseBookingCostByStatus_SumTuitionCost \*
MERGEFORMAT} / {MERGEFIELD CourseBooking_NumberofStudents } \#
"£#,##0.00 } }

For instance, i'm trying to get word to divide the total cost of a
training course by the number of students enrolled - yet when the
calcuation is performed, it shows {= 32456.4300 / 3}, instead of the
actual result.

Can someone help? Just think i need some syntax examples to follow..

many thanks

Ol