Print Avery Labels from Cell Data

R

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 *
* *
******************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top