how to use exel list to print labels

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

Guest

how do I use exel list of names and addresses to print into labels
only option in print is to print envelope
 
There are a number of options. You could use Word's mail merge utility, with Excel
as your database, and with one of the Avery Labels templates to array them on the
sheet. Another is to use formulas or a macro to combine the address fields into
addresses, and array the addresses in a worksheet which has rows and columns sized
to match the label sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top