![]() |
Converting to mailing labels
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 |
Converting to mailing labels
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 |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com