Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adjust line spacing when printing address labels in Excell ? | Excel Worksheet Functions | |||
Does anyone have a template for printing L7160 address labels? | Excel Discussion (Misc queries) | |||
Printing address labels from Excel 2003 | Excel Discussion (Misc queries) | |||
Printing Mailing labels...already have full address in each cell | Excel Discussion (Misc queries) | |||
my merged address labels are only printing ONE page -- answer? | Excel Discussion (Misc queries) |