Converting to mailing labels

[Dave Stitz]

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]

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/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.