how to print lables from worksheet?

[Ross]

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.

 

[Gord Dibben]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

Make sure you have a few sheets of sticky labels available for printing.


Gord Dibben MS Excel MVP

 

[Don Guillett]

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.