Template For Printing Address Labels

  • Thread starter Thread starter Wayne Wengert
  • Start date Start date
W

Wayne Wengert

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailing labels using only Excel? 4
Using Contacts Category as list for printing labels 17
Create page of labels with return address 1
print labels 2
How to create a template to type avery labels; diff on each label 2
Convert a Word address label file to an Excel spreadsheet 2
How do I print mailing labels from an Excel file? 5
Printing on Labels 1

Back
Top