I am trying to print mail labels using MS Word Mail Merge with a Data Source
file prepared in MS Excel. All goes well up to immediately prior to merging
- at this stage the label layout is perfect (the labels I'm using are Avery
7163 - 14 on an A4 page, 7 rows of 2 labels). However, after the merge
operation is completed Print Preview shows an extra half label with 2 or 3
lines of the eighth row of labels printed on it, followed by the next page
which starts with the whole of the eighth row displayed correctly; it then
carries on correctly until the bottom of each page when the same problem
occurs again and again. In practical terms all the labels are printed but the
bottom pair on each page have to be discarded. Something seems to be going
wrong at the Merge stage - can you please tell me what I'm doing wrong?

There have been some reports that problems such as this have been caused by
having the Allow A4/Letter paper resizing option set under
ToolsOptionsPrint.

What happens if you execute the merge to a new document? Does it appear
correct?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"BrianH" wrote in message
...
I am trying to print mail labels using MS Word Mail Merge with a Data
Source
file prepared in MS Excel. All goes well up to immediately prior to
merging
- at this stage the label layout is perfect (the labels I'm using are
Avery
7163 - 14 on an A4 page, 7 rows of 2 labels). However, after the merge
operation is completed Print Preview shows an extra half label with 2 or 3
lines of the eighth row of labels printed on it, followed by the next page
which starts with the whole of the eighth row displayed correctly; it then
carries on correctly until the bottom of each page when the same problem
occurs again and again. In practical terms all the labels are printed but
the
bottom pair on each page have to be discarded. Something seems to be going
wrong at the Merge stage - can you please tell me what I'm doing wrong?