missing records in xp mail merge

[greg]

Hi,

I'm using office xp, ms word and access and i'm trying to print a songbook
from data in an access database. There are over 20,000 records and I have it
set up like:

{myTitle} tab {myArtist} tab {myDisc}
{nextrecord}

the title, artist disc fields are from a linked access query, and the
nextrecord is a word merge field. Everything works ok, except that it only
returns a little over 10,000 records. And it doesn't just grab like the
first 10,000, because i end up with a list from a to z, so for some reason it
is skipping records. There really isn't anything odd about the data that i
can see, and so I can't figure out why this wouldn't working correctly.
Anyone have any idea?

thanks
greg

 

[Doug Robbins]

I assume that you are using a Directory type mailmerge main document and for
that, you do not need the <<Next Record>> field. The effect of using it is
that you get every other record, hence only half of the total.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP