Thread: LABELS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net Martin ©¿©¬ @nohere.net is offline
external usenet poster
 
Posts: 80
Default LABELS

On Fri, 1 Aug 2008 07:07:17 -0700, Teddy-B
wrote:
Is there any type of label maker that is compatable with excel? I seems like
we should be able to plug one in - and print a formatted selection directly
from excel to the label printer. I have been told that the DYMO printers all
require data entry and a separate program. I don't want to use mail merge
either. I want to keep it simple so that I can highlight a formatted area and
PRINT-SELECTION directly to the label printer. Any Ideas?


Hi Teddy
I use Mail Merge Helper in word to print out labels from info stored
in Excel (the data source)

First you would need to decide on a label size to suit your needs,
for example I use an A4 page with 21 labels on it (3 across x 7 down)
which gives a label 1.5"w x 2.5"h

Word has many label templates that suit Avery labels
It will take time to setup your first run what with choosing label
sizes\templates etc,etc, but once you know your needs, doing a print
run is quite simple
If I can Help further just e-mail me at
eandm AT sky DOT com
--
Martin
©¿©¬