Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am working in Excel 2003 and always export data from our accounting system
to Excel for mailing labels. Is there an easy/efficient way to convert the data in an excel spreadsheet to print on an Avery Label? Thank you for your time. Dave |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'd keep the data in excel and use MSWord to print the labels.
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 your data has zipcodes and you want to keep a nice format: 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. Dave Stitz wrote: I am working in Excel 2003 and always export data from our accounting system to Excel for mailing labels. Is there an easy/efficient way to convert the data in an excel spreadsheet to print on an Avery Label? Thank you for your time. Dave -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting spreadsheet info onto mailing labels? | Excel Worksheet Functions | |||
Mailing Labels | Excel Discussion (Misc queries) | |||
mailing labels | Excel Worksheet Functions | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) | |||
Making Mailing Labels | Links and Linking in Excel |