Thank you very much.
"Peter Jamieson" wrote:
[Quoted Text] > People ocasionally report that Word MailMerge freezes, so you are not alone,
> but I don't think it has ever been established /why/ those freezes have
> occured, so maybe that's not much help.
>
> Some questions/suggestions:
> a. is this also Word 2002, or are you using one version of Word and a
> different version of Access?
> b. are you connecting using the default method (OLE DB in Word 2002) ?
> c. how do you know the query generates 600 records? Is that because the
> query returns 600 records when you run it in Access, or because you can skip
> to record 600 in Word MailMerge preview, or what?
> d. can you modify the query criteria, for example to sequence the records
> in a different way? If so, do you find that the merge hangs after 89 records
> (which might suggests that the problem is related to the record count rather
> than content) or that the merge hangs on a specific record ( in which maybe
> there is something unusual about the content)
> e. does the query return exactly the columns you need for the merge, or
> lots of additional columns that you do not need? If it returns more columns
> than you need, can you modify the query to reduce the column count?
> f. does the query return memo fields? If so, how many per record?
>
> I don't know if the above questions will lead anywhere but they are the sort
> of things I would start looking at.
>
> Peter Jamieson
>
> "Victor Lazlo" <VictorLazlo[ at ]discussions.microsoft.com> wrote in message
> news:86E97A5B-A807-4068-ACBC-4AB5834CE67D[ at ]microsoft.com...
> > Using MS ACCESS 2002 query as a record source for merge. My merge document
> > freezes up at specific record (89 inmy query) yet the query generated 600
> > records. Is there a limit to the number of records word will merge to?
> > Or
> > is there someother reason for the merge to freeze or not even function
> > properly as it does not find specific records when using the binoculars
> > option to search for a specific record
>
>
>
|