Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Address Labels
Hi all,
Given a sheet with many rows of name, address data, are ther any "standard" routines for converting / printing the data in address format. ? Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Address Labels
Hi Don,
If you have Microsoft Word you would use Word with Excel as the database. See http://www.mvps.org/dmcritchie/excel/mailmerg.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Don Lloyd" wrote ... Given a sheet with many rows of name, address data, are ther any "standard" routines for converting / printing the data in address format. ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Address Labels
Don, if the data is all in one column and you want to separate have a look
at data text to columns, if the data is allready in columns and you want to print it on lables I would do a mail merge with word, For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Don Lloyd" wrote in message ... Hi all, Given a sheet with many rows of name, address data, are ther any "standard" routines for converting / printing the data in address format. ? Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Template For Printing Address Labels | Excel Programming |