Solved

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

Posted on 2009-04-09
11
3,590 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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

I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

752 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