View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?