Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
JoBear JoBear is offline
external usenet poster
 
Posts: 2
Default Creating mailing labels in Word from Excel merged data

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?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Creating mailing labels in Word from Excel merged data

Depending on version, see:

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

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


--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"JoBear" wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
JoBear JoBear is offline
external usenet poster
 
Posts: 2
Default Creating mailing labels in Word from Excel merged data

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" wrote:

Depending on version, see:

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

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


--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"JoBear" wrote in message
...
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?




  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Creating mailing labels in Word from Excel merged data

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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"JoBear" wrote in message
...
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" wrote:

Depending on version, see:

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

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


--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"JoBear" wrote in message
...
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?







  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Creating mailing labels in Word from Excel merged data

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



JoBear wrote:
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" wrote:

Depending on version, see:

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

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


--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"JoBear" wrote in message
...
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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating Word mailing labels from Excel data DL, Wisconsin Microsoft Word Help 5 July 23rd 07 09:18 PM
Merged address data from Excel won't fit into labels doc in Word Helen Birmingham UK Microsoft Word Help 1 February 14th 07 05:41 AM
How do I go to a second page when creating mailing labels? rvrrat Microsoft Word Help 1 January 3rd 07 05:39 AM
Creating Mailing labels HB Microsoft Word Help 1 December 29th 05 06:37 PM
creating address labels in word from excel data - date changes Daisy66 Microsoft Word Help 3 June 7th 05 04:08 AM


All times are GMT +1. The time now is 11:17 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"