Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i am trying to print lables that are 3" by 5" on a tractor feed system
printer and the page set up dose not allow me to change the size so it starts the next lable in the right spot. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Without looking at all, do you know if Avery has the 3x5 labels (tractor feed).
If they do, maybe you could just use excel as your database and use MSWord's mailmerge feature. Here are a couple of links: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. bean guy wrote: i am trying to print lables that are 3" by 5" on a tractor feed system printer and the page set up dose not allow me to change the size so it starts the next lable in the right spot. -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
We use a tractor feed printer for labels and in order to define the proper
paper/lable size, In Windows XP, I defined a new form size: Go into your list of printeres (in classic mode: Start, Settings, Printers and Faxes) Choose FILE, Server Properties. Define the specs you need for your label if not already available. I created one 4x3 label with: paper size 4.75 inches wide, 3 inches tall Say ok to save your new paper definition. Then in your printer properties, define that paper as the default setting for the printer (instead of letter). You may also need to open your file (I use Excel), and manually switch to that printer and choose that paper choice in the printer properties. Once saved, that paper choice stays for that printer and the labels print properly, moving up only enough for one label at a time. -Sam "Dave Peterson" wrote: Without looking at all, do you know if Avery has the 3x5 labels (tractor feed). If they do, maybe you could just use excel as your database and use MSWord's mailmerge feature. Here are a couple of links: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. bean guy wrote: i am trying to print lables that are 3" by 5" on a tractor feed system printer and the page set up dose not allow me to change the size so it starts the next lable in the right spot. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem Scaling to 1 Page Wide | Excel Discussion (Misc queries) | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
Customize page size | Setting up and Configuration of Excel | |||
Can it be done | Excel Worksheet Functions |