how to format and print labels from an excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
If you have Word, it is easier to do a tools/mail merge from there using
excel as the data.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine rows to print on one label 2
How do I print mailing labels from an Excel file? 5
Combining Rows on a label 1
Make a cell with a list of values (#s, text) from other cells 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How can I have Excel cells populate a Word label template? 1
How to print vendor file lables from an excell file 2
How do I print labels from an existing excel spreadsheet? 1

Back
Top