extra record in mail merge

S

sierralightfoot

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?
 
P

Phil Smith

sierralightfoot said:
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?
Click to expand...
Just one more record? Could it be that the Publisher is seeing a header
row as a record to be merged?
 
S

sierralightfoot

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

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.
 
Top