Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Phoenix, Arizona, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mailmerge - field calculation error (Word 2000)

    I did a search to see if anyone else has had this problem in the past and I found that someone posted the same problem I am having back in November of 2001. It appears no one responded. That person was using Word 97. I am using Word 2000 and the same exact error is occurring. This is what is happening:

    I have a fairly simple one page mail merge letter using an equally simple Word data source.

    My problem is that when I merge to a new document, I get "a field calculation error occurred in record 1". If I acknowledge this error , it repeats the message for record 2, 3 etc. and then everything prints perfectly. As it was only 12 records, it did not take long to step through this string of messages but I can't find what is causing this.

    I have attached the letter and will attach the date source separately, as I got a message saying the file was too big to post.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: mailmerge - field calculation error (Word 2000)

    There seems to be some kind of corruption in the letter. Try the following:
    <UL><LI>Open the letter
    <LI>Select everything except the final paragraph mark (Ctrl+A, then Shift+left arrow)
    <LI>Copy to the clipboard (Ctrl+C)
    <LI>Create a blank new document (Ctrl+N)
    <LI>Paste (Ctrl+V). This will copy all text, but not the header and footer
    <LI>Switch back to the letter (Ctrl+F6)
    <LI>Double click the header, then select everything except the last character (Ctrl+A, then Shift+left arrow)
    <LI>Copy to the clipboard (Ctrl+C)
    <LI>Switch to the new document (Ctrl+F6)
    <LI>Select Edit/Header and Footer
    <LI>Paste (Ctrl+V)
    <LI>Repeat for the footer.
    <LI>Make the new document into a mail merge letter, selecting the same data document.
    <LI>You don't need to insert merge fields - they are already there.
    <LI>Perform the merge.[/list]HTH

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Phoenix, Arizona, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mailmerge - field calculation error (Word 2000)

    Thanks, Hans, this solved the problem.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: mailmerge - field calculation error (Word 2000)

    In case anyone wants to test for themselves, this is the data document.
    Attached Files Attached Files

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Phoenix, Arizona, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mailmerge - field calculation error (Word 2000)

    Hans, the user who had this problem reports that every time she creates a letter, from my template and sets it up for a mailmerge, this field calculation problem occurs. Would you be willing to look at the template to determine if the template is causing this problem? I have attached the template in a zip file.
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: mailmerge - field calculation error (Word 2000)

    OK, later today, it's almost dinner time here. Perhaps others have time to look at it now...

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: mailmerge - field calculation error (Word 2000)

    Hi Jan,

    The template contains the same corruption. It even made Word crash after having it open for 20 minutes or so. I have created a new one by copying the entire contents except for the last paragraph mark, and then copying headers and footers, styles, macros and custom toolbar. I have attached this template (zipped). Please check very carefully that it works OK before replacing the corrupt original.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •