Mail Merge issue

[Bernie]

We have access database which contains records of mail
labels needed to be printed. ABC corp. has 5 entries, XYZ
has 20 entries and DEF Corp has 10 Entries. We have a
query in Access that pulls the records and we use that
query as the datasource for Word mail merge document. Here
is the issue;

When we merge into New Document (or print labels) ABC
corp. shows 6 labels, XYZ shows 18 labels and DEF corp.
has 10 labels.

I have used both <<next record>> and <<next record if not
blank>> (which is what the access query does - removes
blank records) and the result is the same.

The access query shows the correct amount of records!

What is causing some records to be removed and other to
have too many when merged into Word?

We have Office XP loaded on XP Pro.

TIA for any help you guys can provide

Bernie

 

[Peter Jamieson]

If you create a catalog/directory type merge with no <<next record.. or
<<next record if>> type fields, do you still see the same problem?

Peter Jamieson

 

[Doug Robbins]

I don't know what is causing the problem, but why don't you use the label
report wizard in Access?

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

 

[Bernie]

Thanks for the suggestion, I have tried that and same
result. I have also done the merge by using either Excel
or Word as the data source.. same result. I have not come
across solution at this point. Thanks for the suggestions