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/
_______
