Creating mailing labels in Word from Excel merged data

[JoBear]

My goal was to create mailing labels for my Christmas cards. I followed the
Office Online instructions for creating the labels, for a recipient list of
about 100. At the end of the process, instead of all the labels on the page
being filled to the end, each of the 100 addresses prints in the first label
of the page (essentially, 100 pages instead of about 3 1/2 if all the labels
on the page were populated with data).
How do I fix this?

 

[Suzanne S. Barnhill]

Depending on version, see:

Mail merge labels with Word XP (also covers Word 2003)
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Mail merge labels with Word 2007
http://www.gmayor.com/merge_labels_with_word_2007.htm

 

[JoBear]

Sorry, Suzanne, but these instructions (for Word 2007) seem even more
complicated than the Office Online instructions, at least for those of us who
aren't technically-oriented. With the Office Online instructions, I
completed the process, but I don't know in which step I erred to not have a
unique address on each of 30 labels on the page. I did get unique address
labels, but they printed one per page in the top left label. Is there an
easy fix to this, or at least a clear step-by-step that addresses only this
problem?

Thanks.

 

[Suzanne S. Barnhill]

It sounds as if you didn't propagate the labels properly since they don't
seem to have a «Next Record» field in each one but the first.

 

[Graham Mayor]

I did try to make my web page as comprehensive as possible - especially for
someone used to earlier Word versions. It follows the steps you need
logically and illustrates the options and pitfalls along the way. In your
case there are possibly two issues

1. You have not set the merge document type to mailing labels
and/or
2. You have not propagated the labels (In Word 2007 propagate is called
Update Labels). That tool is only available if you have complied with 1.

Both are covered on my web site with pictures!

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>