RE: Problems with converting data held in an Excel spread*** to Word

From: Cindy M -WordMVP- (C.Meister-C_at_hispeed.ch)
Date: 07/06/04

  • Next message: Cindy M -WordMVP-: "Re: Access query merge error" 
    Date: Tue, 06 Jul 2004 10:21:43 +0200

    Hi =?Utf-8?B?bWFyayBHcmF5?=,

    Ah, I understand what's happening, I think.

    You're apparently doing a PasteLINK to the data in Excel. But the link is going to carry
    across ALL the information, and Word will try to reconcile the records that aren't visible.

    You need to paste the table into Word without a link.

    > I collect a lot of data in excel, including field headings such as Title, Initials,
    Surname, Address line 1, Address line 2 ........ Scheme, Annual Amount .. etc..
    > This data is extracted from a separate application.
    >
    > I then filter the data (using auto filter), so I say only get members of scheme 1 not
    scheme 2 and 3.
    >
    > I then copy and paste this data to a new word document, where I format the Name and
    Address field columns (singularly rather than in bulk) so that all alpha fields are 'title
    case' sensitive.
    >
    > I then try and do a mail merge in word to this data, and get the word error messages
    about missing cell data (ie one record may not have an entry in address line 4, but others
    do), and also I get all schemes, rather than just scheme 1, and also the reformatting to
    'title case' is reverted back to the original case.
    >

    Cindy Meister
    INTER-Solutions, Switzerland
    http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
    http://www.word.mvps.org

    This reply is posted in the Newsgroup; please post any follow question or reply in the
    newsgroup and not by e-mail :-)

  • Next message: Cindy M -WordMVP-: "Re: Access query merge error"