how to format and print labels from an excel file

D

DDAANN

I have an excel list of people with 12 cells of information. I want to
format and print "name tags" (labels?) using only the information in four
cells. How can I do this?
 
G

Gord Dibben

You can print labels in Excel but formatting can be a problem.

Best to use Word for the mailmerge operation and select the 4 labels to print
during the setup in Word.

For help on Word mail merge using Excel as the data source.

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

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033


Gord Dibben Excel MVP
 
M

Marvin P. Winterbottom

If you have Word, it is easier to do a tools/mail merge from there using
excel as the data.
 
Top