Mailmerge calculations syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oly - 16 Feb 2006 15:21 GMT

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

Reply to this Message

Graham Mayor - 16 Feb 2006 17:07 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Hi there
>
[quoted text clipped - 17 lines]
>
> Ol

Reply to this Message