| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| export cells to print in avery 5167 format | Excel Worksheet Functions | |||
| Can I use Avery Labels with Excel? | Excel Discussion (Misc queries) | |||
| How do I print my excel contact sheet into avery labels | Excel Worksheet Functions | |||
| How can I generate avery address labels from database | New Users to Excel | |||
| Producing Avery labels in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
