Printing lables from excel

  • Thread starter Thread starter Damian
  • Start date Start date
D

Damian

Hope someone can help
My problem is this.
I have an excel work sheet with a packing list on sheet (1)
ITEM NO. QTY. PART NO.
1 1 Oven Base
2 36 Default
3 29 Oven Internal Wall<AsMachined>
4 18 Oven Ext. Roog
5 8 Center Sil. Infill
6 8 Plenium End Walls
7 16 Center Sil. Upper
8 8 Sil. Lower
9 4 Center Sil.
10 1 Flash Off Tunnel Wall
11 4 Flash Off Tunnel Wall Floor
12 2 Flash Off Tunnel Wall Center Side
13 1 Plenium Chamber Wall
14 1 Epac Floor
15 1 Hot Box Stand
16 15 Oven Internal Roof
17 58 OVEN WALL PANEL Damper

Is there any way with a macro to print out lables of each item many times
per item .The amount of tmes to print would be derived from column (b) and
the item to print would come from column (c). The macro would also need to
format the lable with extra text and font


Thank you
Damian

--
----------------------------
Couray Sheetmetal
9 Apsley Plc.
Seaford
Melbourne.
Australia.
PH 03 97861609

---------------------------
 
Use Word. Set up the labels with fields (read about 'mail merge') in Word
and specify that the data is in an Excel workbook
 
Damian, to add to Bernard's, have a look here for more on using Mail Merge
with data from Excel

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
I had a look at using the Word option but it really dosn't do what i need.
My problem is that I am using a program that has an embeded Excel sheet in
it. This program called Soliworks generates a Bill of Materials in an Excel
sheet. I guess what i am looking for is some idea how to copy cell B2 into
Sheet 2 by the amount shown in A2 but sheet 2 has a format set up to suit a
label that we use. I would have to do this up to 20 times a day

Bernard Liengme said:
Use Word. Set up the labels with fields (read about 'mail merge') in Word
and specify that the data is in an Excel workbook
Click to expand...
 
Back
Top