Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to print lables from worksheet?
How can I print lables from an excel worksheet?
Or How can I convert the spreadsheet to Word and then print lables? Please help me. My boss will kill me if I can't get the task done. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to print lables from worksheet?
Excel alone is poorly suited for label printing.
Use Word's mailmerge...........labels and envelopes. Assuming you are using Word for the mailmerge and Excel for the source see these sites for help. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm Make sure you have a few sheets of sticky labels available for printing. Gord Dibben MS Excel MVP On Mon, 1 Dec 2008 16:20:00 -0800, Ross wrote: How can I print lables from an excel worksheet? Or How can I convert the spreadsheet to Word and then print lables? Please help me. My boss will kill me if I can't get the task done. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to print lables from worksheet?
As Gord said, MUCH better to use mail merge but you could do it if you set up a sheet and tested a lot to get it right and then developed a macro to import the names (again, tricky due to name list layout) and addresses. I print envelopes from a mailing list by a simple double click on the name to populate the envelope. I have it set up for a couple of envelopes. Again, tailored to your printer. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ross" wrote in message ... How can I print lables from an excel worksheet? Or How can I convert the spreadsheet to Word and then print lables? Please help me. My boss will kill me if I can't get the task done. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print lables from excel names and address list | Excel Discussion (Misc queries) | |||
Print Column Heads WITHOUT Excel Column Lables | Excel Worksheet Functions | |||
how do u print back2back print of different worksheet in exel. | Excel Worksheet Functions | |||
lables | Excel Discussion (Misc queries) | |||
print a specific area within a worksheet by clicking on print? | Excel Worksheet Functions |