View Single Post
  #8   Report Post  
Graham Mayor
 
Posts: n/a
Default

The error implies that you have an erroneous leading bracket (that's the
first error it finds). This suggests that there is a problem with the way
you have inserted the fields.

All the field combination does is to divide the content of the field by
10,000. In order for this to work, the field must contain a numeric value. I
know that you have said that you you inserted the fields using CTRL+F9, but
let's try a different tack.

Press CTRL+F9 which will give you
{}
Between the brackets type =( /10000)
Immediately after the first round bracket, insert the mergefield from the
drop down on the merge toolbar
{=(fieldname / 10000)}
Does it work now?

If not, check your data file to see what the field actually contains - a
simple way to do this is to create a temporary catalog merge containing both
the uncalculated field and the calculation on the same line. Merge to a new
document.


--

Graham Mayor - Word MVP

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





jdawgnat wrote:
It's an odd situation. It works on the initial letter in the mail
merge and calculates fine. As I go through to the rest of the letters
in the merge, it tells me

!Syntax Error, {

I am not sure why it would work on the first one and not the next
letters.