Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jgatokdhs jgatokdhs is offline
external usenet poster
 
Posts: 2
Default Why do I get "A field caluclation error occured in record N"?

I'm just doing a simple mail merge in Word 2003. The data source is an excel
2003 spreadsheet. If I click OK on the error, I get the same error on every
record, yet the finished document is perfect. Why am I getting the error or
how can I find out specifically what Word is complaining about?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Why do I get "A field caluclation error occured in record N"?

First, I would have a look at all the field codes by using Alt-F9 to display
the { } versions of the codes.

Do you have anything except { MERGEFIELD } type fields? Do you have any
pictures or linked objects in the document?

Peter Jamieson
"jgatokdhs" wrote in message
...
I'm just doing a simple mail merge in Word 2003. The data source is an
excel
2003 spreadsheet. If I click OK on the error, I get the same error on
every
record, yet the finished document is perfect. Why am I getting the error
or
how can I find out specifically what Word is complaining about?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jgatokdhs jgatokdhs is offline
external usenet poster
 
Posts: 2
Default Why do I get "A field caluclation error occured in record N"?

All the fields are {MERGEFIELD}. There are no pictures or any other linked
objects other than a State Seal and DHS Logo in the heading of the document.

"Peter Jamieson" wrote:

First, I would have a look at all the field codes by using Alt-F9 to display
the { } versions of the codes.

Do you have anything except { MERGEFIELD } type fields? Do you have any
pictures or linked objects in the document?

Peter Jamieson
"jgatokdhs" wrote in message
...
I'm just doing a simple mail merge in Word 2003. The data source is an
excel
2003 spreadsheet. If I click OK on the error, I get the same error on
every
record, yet the finished document is perfect. Why am I getting the error
or
how can I find out specifically what Word is complaining about?




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Why do I get "A field caluclation error occured in record N"?

I would probably try a number of things with a reduced size data source
including:
a. Make sure you are seeing /all/ the fields including hidden fields (e.g.
also check Word Tools|Options|View|All)
b. Make sure you have actually selected all the fields in the document and
executed them (e.g. using F9) before merging. (This shouldn't affect
MERGEFIELD fields though)
c. copy some records from my data source into a completely different format
d. copy/paste the main body of the document into a completely new Word
document and try that
e. remove things one by one and re-execute the merge until the problem
disappears. I'd probably actually start with the pictures, then remove each
field in turn.

Peter Jamieson

"jgatokdhs" wrote in message
...
All the fields are {MERGEFIELD}. There are no pictures or any other
linked
objects other than a State Seal and DHS Logo in the heading of the
document.

"Peter Jamieson" wrote:

First, I would have a look at all the field codes by using Alt-F9 to
display
the { } versions of the codes.

Do you have anything except { MERGEFIELD } type fields? Do you have any
pictures or linked objects in the document?

Peter Jamieson
"jgatokdhs" wrote in message
...
I'm just doing a simple mail merge in Word 2003. The data source is an
excel
2003 spreadsheet. If I click OK on the error, I get the same error on
every
record, yet the finished document is perfect. Why am I getting the
error
or
how can I find out specifically what Word is complaining about?






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
"Print current page" should have a "+n pages" field. rawahoho Microsoft Word Help 5 November 16th 06 03:26 PM
"h" and "t" allowed in form Number field Lori S Microsoft Word Help 1 October 17th 06 10:49 PM
files I want to "save as" are all showing "file permission error" PHDOC Microsoft Word Help 0 May 24th 06 05:28 PM
Error msge"Microsoft office "" not been installed for the current unjida por Dios Microsoft Word Help 1 April 21st 06 06:51 PM
New field for Word: {SCREENTIP "DisplayText" "TipText"} DQC from Prescott AZ Microsoft Word Help 1 March 17th 06 11:29 PM


All times are GMT +1. The time now is 11:59 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"