Print Avery Labels from Cell Data
 

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 *
* *
******************
--
Cheers,
Ryan

Print Avery Labels from Cell Data
 

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/Pro...Mail-Merge.htm

HTH,
Bernie
MS Excel MVP


"Ryan H" wrote in message
...
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 *
* *
******************
--
Cheers,
Ryan

Print Avery Labels from Cell Data
 

The Avery web site has an addin wizard.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ryan H" wrote in message
...
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 *
* *
******************
--
Cheers,
Ryan