mail merge labels duplicating

K

Kathy

I need some help. I am using word 2008 and excel data to create a
label mail merge.
I create the labels. On label page 1, the labels sequence correctly
(Jane, Steve, Susan, Mike, Laura, Joe, etc.), but on label page 2 the
labels sequence Steve, Susan, Mike, Laura, Joe, etc. On label page 3
the labels sequence Susan, Mike, Laura, Joe, etc. Each page label 1
starts with the next record and cycles through the data. As a result
to get the correct label pages I would have to print pages 1, 31, and
61 rather than pages 1-3 with all of the labels appearing just one
time.
There is no <next record> in the first label, but there is a <next
record> in all of the other labels.
thanks
 
C

CyberTaz

Without knowing exactly how you've gone about it step-by-step I'm not
certain of exactly what might be happening. I'm afraid "I create the
labels." really doesn't disclose very much. However, when steps of the Mail
Merge Manager (MMM) are followed I've never seen this happen.

Try from scratch again starting with a blank document. Complete the MMM
steps in the order they're presented & finish by clicking the Merge to New
Document button as the final step (#6).

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
K

Kathy

Without knowing exactly how you've gone about it step-by-step I'm not
certain of exactly what might be happening. I'm afraid "I create the
labels." really doesn't disclose very much. However, when steps of the Mail
Merge Manager (MMM) are followed I've never seen this happen.

Try from scratch again starting with a blank document. Complete the MMM
steps in the order they're presented & finish by clicking the Merge to New
Document button as the final step (#6).

HTH |:>)
Bob Jones
[MVP] Office:Mac

thanks CyberTAz
I discovered that this wierd thing happens when I preview the labels.
But when I actually complete the MM and "merge to document" the labels
work out ok with a little adjustment.
 
P

Peter Jamieson

As you have discovered, preview isn't really a "page by page" Preview of
the expected output /document/.

All it does is populate the mail merge main document starting with the
data record that is currently selected. (Nor does it always format the
document the same way as it does if you actually merge to the printer).

Peter Jamieson

http://tips.pjmsn.me.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top