Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2005

Tip: Looking for answers? Try searching our database.

How to print a full sheet of labels for each person on a list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Powell@BCC - 23 Mar 2005 23:17 GMT
How do I print a full sheet of labels for each person on a list of about 200
names?  I have Office XP.  My list of names is in Access. I have tried doing
a regular mail merge in Word, but I can only get 1 label for each name on my
list.  I am using Avery 5167/5267 labels--80 per sheet. Is there an automatic
way to do this?
Graham Mayor - 24 Mar 2005 09:16 GMT
Create the label merge, then change the document type from label to form
letter from the merge toolbar and remove any NEXT fields from the labels,
then merge.
See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
Alternatively use New document option from the envelope/label wizard dialog,
which will give you a blank sheet of labels. Use this as the basis for a
form letter merge. Put your fields in the first label, then select the
content of that cell and copy to the clipboard. Select the whole table and
paste the clipboard content. Merge the resulting document.

Signature

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

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

> How do I print a full sheet of labels for each person on a list of
> about 200 names?  I have Office XP.  My list of names is in Access. I
> have tried doing a regular mail merge in Word, but I can only get 1
> label for each name on my list.  I am using Avery 5167/5267
> labels--80 per sheet. Is there an automatic way to do this?
Powell@BCC - 25 Mar 2005 15:49 GMT
THANKS!!!

I was able to use your alternate suggestion and make it work.  I've been
pulling my hair out for a week trying to make this work.  Thanks again for
responding.
Valerie Powell@BCC

> Create the label merge, then change the document type from label to form
> letter from the merge toolbar and remove any NEXT fields from the labels,
[quoted text clipped - 11 lines]
> > label for each name on my list.  I am using Avery 5167/5267
> > labels--80 per sheet. Is there an automatic way to do this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.