mail merge only merges odd records from query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am merging an Access 2000 parameter query into a Word 2000 form letter.
Everything seems fine, except only 4 of the 7 records I've filtered for are
showing up--Only the odd-numbered records. I have another form letter linked
to this query and my OS is XP, if that has any relevance.
 
If you run the Query in Access, does it return 4 or 7 Records?

If it returns 4, check the criteria in your Query.

If it returns 7, the Access end is fine. You will need to check your
MailMerge document as the MailMerge can put additional filter on top of the
criteria in Access.
 
The query is fine--it's the only reason I knew I wasn't getting all of my (7)
results in my mail merge document. When I reun the mail merge, I have "all
records" checked to merge. Is there another filter in the mail merge
document that I need to check on? (This morning I was wishing I had an even
number of records--I'd just switch the sort from ascending to descending and
run a second time:)
 
I can get the even records to merge if I select to merge records 2 through 7
(or last record, I suppose). This is a bit annoying, though, and I abhor
tedium. I really want to know WHY! If anyone has run into this before, I'd
appreciate a solution, but as long as I have a way around it, I won't worry
about it right now.
 
I would suggest posting the question in one of the relevant Word newsgroups
since it sounds OK in Access. Admittedly, I haven't seen this behaviour
before.
 
I found out that there is no need to insert the MailMerge field <<Next
Record>> at the end of a form letter--so I was essentially skipping a record.
A basic problem for new mailmergers, I'd assume. Word treats the end of
your mailmerge document as a cue for the next record.
 
THanks for letting us know the cause. I have done ton of MailMerge from
Access but I never use <<Next Record>>.
 
Back
Top