If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merge - Field Calculation Error Occurred on Word XP
I am completeing a mail merge for over 850 records. I have no formulee
and the data is in the first workbook for the mail merge. My problem being, i am getting the "Field Calculation Error occurred on record 1, 2, 3, etc". If i do a small run, it looks perfect, but i have to ok the error statements. To have attempted to remedy the situation by copying the data into a new file, checked all the column headings with the merge fields on the statement and have played around with the format of the statement but to no avail. I have also accepted any track changes that were outstanding. How can i remove this error? Can anyone help me as i have ran out of ideas. Many Thanks Mal Wilson |
#2
|
|||
|
|||
I have been experiencing the same error today. I found some documentation that suggested that there would be a field calculation error if any of the cells in Excel are blank. Unfortunately, that explanation doesn't make sense. Another possibility in my case is that I was using the includetext command to pull in other Word docs. (If condition is true, pull in document A, but if false, pull in document B.) It used to work fine, but not as of today. I embedded all my extra documents in the main doc and the errors stopped. My only problem now is that my main document is huge and unwieldy. Using Word 2002 and Windows 2000, Peggy -----Original Message----- I am completeing a mail merge for over 850 records. I have no formulee and the data is in the first workbook for the mail merge. My problem being, i am getting the "Field Calculation Error occurred on record 1, 2, 3, etc". If i do a small run, it looks perfect, but i have to ok the error statements. To have attempted to remedy the situation by copying the data into a new file, checked all the column headings with the merge fields on the statement and have played around with the format of the statement but to no avail. I have also accepted any track changes that were outstanding. How can i remove this error? Can anyone help me as i have ran out of ideas. Many Thanks Mal Wilson . |
#3
|
|||
|
|||
Hi Peggy,
Another possibility in my case is that I was using the includetext command to pull in other Word docs. (If condition is true, pull in document A, but if false, pull in document B.) It used to work fine, but not as of today. [Word 2002] Might you have installed an SP-update since this worked last? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge in Word 2002 | Pam | Mailmerge | 0 | August 5th, 2004 04:11 AM |
Mail Merge Field Formatting | Janet | Mailmerge | 2 | August 5th, 2004 01:53 AM |
How to run word and pass a mail merge values and fax it to the recipient | Belinda | Mailmerge | 2 | June 13th, 2004 12:49 AM |
How can I force two merge fields to calculation in word 2000 | Jane Humbrey | Mailmerge | 1 | April 30th, 2004 12:34 AM |
Mail merge data source can't be saved word 2003 | richie | Mailmerge | 3 | April 29th, 2004 09:24 AM |