creating labels using MS exel and MS word mail merge

[Bassman]

Hello everyone,
I am trying to make labels for warehouse product showing product
numbers and locations from an placed order. I have a worksheet with
part number, location, and qty in seperate collums. I can setup the
merge to print one copy of each part ordered,no problem, how can I
have multi labels print for an entry if qty is greater than 1? Right
now it will print one label showing qty of 25. This order is very
large. I know I can copy and insert 24 row with the same part
number/
location and it will merge but can it be automated to take the qty
and
print out what ever is needed and then move to the next row/part
number. I am learning excel on my own and with the dummy's book.
lol

The issue is make multiple labels for one row
of information based on the qty of that part number
Like this:
Part number order number Qty
123456 636 2
45678 636 1
987654 636 24

How can I merge and get 2 labels for the 123456 and 24 labels for
987654? Will take too long to cut and paste


Thanks in advance


Thanks in advance

 

[Joel]

The printout method has a quantity. Try something like this


RowCount = 1
Do while range("A" & Rowcount) <> ""
set PrintRange = Range("A" & RowCount & ":B" & RowCount)
PrintRange.Printout(copies:=Range("C" & RowCount)
RowCount = RowCount + 1
loop

 

[Bassman]

The printout method has a quantity.  Try something like this

RowCount = 1
Do while range("A" & Rowcount) <> ""
  set PrintRange =  Range("A" & RowCount & ":B" & RowCount)
  PrintRange.Printout(copies:=Range("C" & RowCount)
  RowCount = RowCount + 1
loop









- Show quoted text -

OK, I am a bit of a rookie. Where do I put the printout method. I
have worked with HTML, javascript, qbasic....lol so I understand a
little, would appriecate any direction.

 

[Joel]

This is the programming postings for excel where most people know a little
about VBA. You can get to the VBA editor at least two ways

1) Right click on the tab on the bottom of the worksheet and select View code
2) From tools Menu - Macro - Visual Basic editor

Look at the Project Window on the left side of the window. If it is not
opened then open it with the View Menu. There are three diffferent place to
put code.

a) Thisworkbook
b) worksheet pages
c) module

You need to add a module from the VBA Insert Menu - Module. Simply paste
the code into the module page.

You can run the code from inside VBA using the Run Menu (or press F5). You
can run code also from worksheet menu buy goin to tools - Macro - Macro and
selecting the macro name.

sub print_range()
RowCount = 1
Do while range("A" & Rowcount) <> ""
set PrintRange = Range("A" & RowCount & ":B" & RowCount)
PrintRange.Printout(copies:=Range("C" & RowCount)
RowCount = RowCount + 1
loop

end sub