A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I print labels on a partial sheet?



 
 
Thread Tools Display Modes
  #1  
Old March 9th, 2010, 11:15 PM posted to microsoft.public.word.mailmerge.fields
Dave U[_2_]
external usenet poster
 
Posts: 2
Default How can I print labels on a partial sheet?

After setting up a set of labels in Word for printing, I can't find a way to
print the first label anywhere but in the upper left position. That means if
I have a partially used sheet of labels, I can't use it -- I have to start
with a full sheet no matter what. Is there a way to get around this so I can
use my left-over label sheets?
  #2  
Old March 10th, 2010, 07:02 PM posted to microsoft.public.word.mailmerge.fields
Rich/rerat
external usenet poster
 
Posts: 423
Default How can I print labels on a partial sheet?

Dave U,
Add "blank" records to your data source above your filled out records. When
you select the records for the merge, include the same number of "blank"
records to your merge, as missing/used labels from the sheet you using. If
you are going to Sort your data, make sure you don't include the "blank"
records in the sort. They should be always be on top or the records list.

So if your label sheets have 30 labels (3X10), and you already used 12
labels, then mark 12 "blank" records plus the records that you want to merge
to the label sheet.

Remember the printing for the merge usually goes:
Left to Right then Down

So you will need to make sure that the labels follow that pattern, if not
you may need to remove the errant label(s), and add more "blank" records to
the merge list.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Dave U" wrote in message
...
After setting up a set of labels in Word for printing, I can't find a way to
print the first label anywhere but in the upper left position. That means if
I have a partially used sheet of labels, I can't use it -- I have to start
with a full sheet no matter what. Is there a way to get around this so I can
use my left-over label sheets?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.