creating labels with excel and 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

Thanks in advance

 

[Gord Dibben]

Excel alone is poorly suited for creating labels.

Do you have Word?

Use Word's mailmerge with Excel or Access as the data source.

Assuming you are using Word for the mailmerge and Excel for the source see these
sites for help.

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

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP

 

[Bassman]

Excel alone is poorly suited for creating labels.

Do you have Word?

Use Word's mailmerge with Excel or Access as the data source.

Assuming you are using Word for the mailmerge and Excel for the source seethese
sites for help.

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

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

Gord Dibben  MS Excel MVP






- Show quoted text -

Yes, I am using word. 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 again

 

[Bassman]

Yes, I am using word.  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 again- Hide quoted text -

- Show quoted text -

Any Ideas anyone?

 

[UNO Howard]

I am needing the exact same information. Often time I will have a list of
forty rows to duplicate into a Word mail merge.