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?
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/MailMe...AMailMerge.htm
http://www.mvps.org/word/FAQs/MailMe...DataSource.htm
And a training tutorial for creating envelopes and labels.
http://office.microsoft.com/training...RC010390291033
Gord Dibben Excel MVP
On Tue, 12 Apr 2005 09:46:03 -0700, DDAANN <[email protected]>
wrote:
>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?
If you have Word, it is easier to do a tools/mail merge from there using
excel as the data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks