Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This sounds like a good opportunity to use excel as your database and MSWord's
mailmerge feature. You may want to read some tips for mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. And if you notice problems with the formatting of data (like zipcodes)... Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") or =text(a2,"mm:ss.0") or =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) address labels wrote: For the life of - I can't remember how to print address labels from an existing excel spreadsheet. HELP. Thank you -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to print address labels from addressbook on excel spreadsheet | Excel Discussion (Misc queries) | |||
excel spreadsheet into address labels | Excel Worksheet Functions | |||
how do I print address labels from an Excel Spreadsheet | Excel Worksheet Functions | |||
how can I print address labels from an excel file | Excel Discussion (Misc queries) | |||
How do I print labels from an Excel spreadsheet | Excel Discussion (Misc queries) |