ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Converting to mailing labels (https://www.excelbanter.com/excel-worksheet-functions/147632-converting-mailing-labels.html)

Dave Stitz

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



Dave Peterson

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