View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default 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