Template For Printing Address Labels
 

We receive CSV format files which contain mailing information (name, addr,
city, state, zip). We want to open these in Excel and print mailing labels
on sheet forms like Avery 5160. Is there a template/macro to do this?

Wayne

Template For Printing Address Labels
 

There may be, but you'd be *FAR* better off using Word, which has this
ability built in... You can read the text file into XL and do whatever
processing you want, then use the file as a data source

See the "Create labels by using the Data Merge Manager" topic in Word
Help.

See also

http://www.mvps.org/dmcritchie/excel/mailmerg.htm



In article ,
"Wayne Wengert" wrote:

We receive CSV format files which contain mailing information (name, addr,
city, state, zip). We want to open these in Excel and print mailing labels
on sheet forms like Avery 5160. Is there a template/macro to do this?