Print Avery Labels from Cell Data

[Ryan H]

I have a list of part numbers and part descriptions that I want to copy to an
Avery Label #5163 (2"x4" Sticker, 10 Stickers per Page). Does anyone know
how to do this in Excel or transfer the data to MS Word?

For example,

Col.A Col.B Col.C
Part # Description1 Description2
11111 screw long
22222 apple green
33333 sign large

I would like the macro to scan down Col.A and format each Part #,
Description1 and Description2 into the 2x4 label like below. Is this
possible?

******************
* Part# *
* Description 1, *
* Description 2 *
* *
******************

 

[Bernie Deitrick]

Ryan,

What you want to do is called a 'mail merge' and is performed from Word. It helps to have your
Excel Database as the only sheet in the workbook - there are plenty of sites with instructions on
mail merge from mailing labels: here's one from Avery:

http://www.avery.com/avery/en_us/Pr...ticles/Take-the-Mystery-Out-of-Mail-Merge.htm

HTH,
Bernie
MS Excel MVP

 

[Don Guillett]

The Avery web site has an addin wizard.