Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2009-04-09
11
Medium Priority
?
5,173 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

606 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