Solved

a field calculation error occured in record #. word mail merge

Posted on 2009-04-09
11
3,150 Views
Last Modified: 2012-06-21
Hi Expert,
I got word document from client and I need merge with excel sheet address book. After merge when I click on edit individule then "a field calculation error occured in record #.", I don't have any calculation field in merge process, but result looks like fine. If I use other word document and same address book, no problem at all. I think client word document probably have problem, but I don't know where is the problem. Because I have 1000 record, when I see error I affraid some data lost.

Thanks in advance.
0
Comment
Question by:dshi15
  • 6
  • 5
11 Comments
 
LVL 19

Expert Comment

by:dlc110161
ID: 24116396
Try repairing the client docement.  Click on the file menu, select open, browse to the client file. Click the down arrow next to the open button and choose Open and repair. If that does not solve your problem then try copying everything in the document Except the final paragraph mark.  (ctrl+a, shift & right arrow, copy)

Dawn Bleuel
Word MVP
0
 
LVL 1

Author Comment

by:dshi15
ID: 24164022
I cannot find "Open and repair".
0
 
LVL 19

Expert Comment

by:dlc110161
ID: 24168622
There is a down arrow to the right of the Open Button. See attached image.

Dawn Bleuel
Word MVP
OpenAndRepair.gif
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 1

Author Comment

by:dshi15
ID: 24178894
what version of Microsoft office word you used? thanks.
0
 
LVL 19

Expert Comment

by:dlc110161
ID: 24188786
The Open and Repair option is available from Word 2002 on forward. Recover Text from any File is available on 2000 and forward (I don't have Word 97 anymore to check)

Dawn Bleuel
Word MVP
0
 
LVL 1

Author Comment

by:dshi15
ID: 24194372
sorry, Now I found open and repair, I looked file menu, open checked arrow in here, so that is why I didn't find in first place. But I tried both ways, it still give error in record, only thing I can do is make the first letter, then use first letter as document then start over, everything will be fine. Do you have other idea?
0
 
LVL 19

Expert Comment

by:dlc110161
ID: 24197159
Unfortunately, no. Once a document gets too corrupted, then your best bet is to create a different document.

Rather than merging to the first letter, you might try opening a new blank document and use the IncludeText field to import the text of the corrupted letter into the new document. Then you can CTRL+A and press SHIFT+CTRL+F9 to convert the Include Text field to text.

Dawn Bleuel
Word MVP
0
 
LVL 1

Author Comment

by:dshi15
ID: 24198127
I opened a new document, but I couldn't find "IncludeText" in any dropdown from menu list. What is next?
0
 
LVL 19

Expert Comment

by:dlc110161
ID: 24199345
From the Insert Menu, choose Field. In the field dialog box, locate IncludeText. Then you have to be able to type in the complete path to your document including .doc

Hope that helps

Dawn Bleuel
Word MVP
0
 
LVL 1

Author Comment

by:dshi15
ID: 24204510
last question, when I incude file, all the line highlighted ( all  the line have gray box surround them), why?
It happened on some file, some file not. sometime I have Error! Not a valid filename. when I inlude file, I'm sure the filename is correct and they are in same directory.
0
 
LVL 19

Accepted Solution

by:
dlc110161 earned 500 total points
ID: 24204827
They all have a gray box around them because the text is inside a field. That's where the Select All (CTRL+A) and Convert Field to Text (CTRL+SHIFT+F9) comes in. The reason you might not be seeing the field in gray is because your cursor is outside of the field. The Error may be because it can't import the text of the file if you are sure that the path and filename is exactly right.

Dawn Bleuel
Word MVP
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question