Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (Word 2000 )

    My data source is an Excel97 file, with text, date and number cells.
    Two problems:

    1. A text cell designated as a field contains words and spaces that total 366 characters = 431 characters+spaces. When the Word field in my main document applies a simple If .. Then .. Else test to the field during the merge, only 215 characters = 254 characters+spaces are ported into the target cell in the Word table to which I'm merging. There are no data validation constraints, and the target cell is large enough to contain 385 characters+spaces in the same font. Why is some of the text not being merged - and what's the fix?

    2. I have given some Excel columns a customized number format, whereby typing 7 when entering the raw data into my source file results in display of P' 07 (parent of a student who will graduate in 2007). When the contents of the cell are ported to the Word document during the merge the custom formatting is lost and the merge field displays 7.00 -- the leading zero is lost and two decimal places are added, although no decimal places are present in the raw data. Can anyone offer explanation and a fix?

    Thanks, Peter

  2. #2
    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: Mail Merge (Word 2000 )

    Number 1 sounds very similar to a familiar problem with Access queries that involve expressions, and probably has a similar underlying cause. Solution #1 is to upgrade to Word 2000 SR-1. Assuming this is impractical, see the advice in <A target="_blank" HREF=http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q242072>WD2000: Field Text Truncated to 255 Characters When Merging or Inserting Database</A>. Does Word 97 have the option to access the .xls file using DDE?
    Attached Images Attached Images

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2000 )

    #1 -- Right on! It truncated at 254 characters+spaces, plus one more space I couldn't see because there was no following character. Many thanks. I apologize for drawing on your valuable time: I'm going to have to learn how to pose questions in MS-speak, so that I can do better forum and KnowledgeBase searches myself.

    #2 MOREOVER the fix you suggested (accessing the Excel data source file by DDE) has also preserved the Excel custom number format whereby 7 is displayed as P' 07 etc. -- a huge time saver in the merge document.
    So both problems are now resolved by the one fix!
    Thanks again,

    Peter

  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: Mail Merge (Word 2000 )

    No need to apologize; I'm glad I was able to help. Someday you will repay the favor by answering the question for someone else. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

Posting Permissions

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