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

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. ?

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