Printing Labels From Excel

  • Thread starter Thread starter GilNisco
  • Start date Start date
G

GilNisco

Hello. We entered our holiday list into Excel, and want
to print mailing labels from it (Avery type, 3 across x 10
down). Is this possible from Execel 97? How is this done?

Thank you for your help. Gil Nisco
 
If you have Word, you can print the labels in pre-formatted tables
designed for Avery labels. You use your Excel file as the mail merge
data source.
In Excel, you must define a named range for your entire list; this
will be the table name in your query.









Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
GilNisco said:
Hello. We entered our holiday list into Excel, and want
to print mailing labels from it (Avery type, 3 across x 10
down). Is this possible from Execel 97? How is this done?
Click to expand...

As others have indicated, use Word's mail merge with your Excel file as the
data source.

Avery helpfully provides templates to do this that match their labels. See
http://www.avery.com/
 
Back
Top