extra record in mail merge

[Guest]

I use an access query as the sorce for a mail merge in a publisher item.
The query, as viewed from access, shows less records than when the merge
takes place in publisher. How can this be?

 

[Phil Smith]

I use an access query as the sorce for a mail merge in a publisher item.
The query, as viewed from access, shows less records than when the merge
takes place in publisher. How can this be?

Just one more record? Could it be that the Publisher is seeing a header
row as a record to be merged?

 

[Guest]

No it is an actual record that is filtered out by the query but appears in
the mail merge

 

[Phil Smith]

Are you sure MailMerge is using the exact same query? If so, then you
might try creating a new query based on the existing one in Access, then
use that in mailmerge. After that, I don't have any good ideas.
Access is not completeley consistent.

Worst case to solve the probel, have access run a make table query, and
base the mailmerge of that table.