What causes field calculation errors in mail merge?

S

Shelley78

Merging a document and I get the following Mail Merge message: A field
calculation error occured in record 1.
 
D

Doug Robbins - Word MVP

I have experienced receiving that error message when using a field
construction such as:

{ IF { REF Check } <> "{ MERGEFIELD itemnumber } { MERGEFIELD itemprice } "
"{ MERGEFIELD itemnumber } { MERGEFIELD itemprice }¶
" }{ SET Check "{ MERGEFIELD itemnumber } { MERGEFIELD itemprice }" }

But after clicking on the OK button to dismiss the error message, the merge
executes as required.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
P

Peter Jamieson

I believe that particular problem occurs when the { SET } field has been
inserted but not actually executed. At that point there is no "Check"
bookmark, so the REF field causes an error. After the { SET } field has been
executed once, the error disappears.

Peter Jamieson
 
M

macropod

Hi Shelley,

What is the field coding that generates the error? If it uses any REF
fields, what's the coding for the source fields too?

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top