creating labels with excel and mail merge
 

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

creating labels with excel and mail merge
 

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Fri, 18 Apr 2008 23:48:02 -0700 (PDT), Bassman wrote:

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

creating labels with excel and mail merge
 

On Apr 19, 9:25*am, Gord Dibben <gorddibbATshawDOTca wrote:
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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben *MS Excel MVP



On Fri, 18 Apr 2008 23:48:02 -0700 (PDT), Bassman wrote:
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- Hide quoted text -

- 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

creating labels with excel and mail merge
 

On Apr 19, 1:13*pm, Bassman wrote:
On Apr 19, 9:25*am, Gord Dibben <gorddibbATshawDOTca wrote:





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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben *MS Excel MVP

On Fri, 18 Apr 2008 23:48:02 -0700 (PDT), Bassman wrote:
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- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

Any Ideas anyone?

creating labels with excel and mail merge
 

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

"Bassman" wrote:

On Apr 19, 1:13 pm, Bassman wrote:
On Apr 19, 9:25 am, Gord Dibben <gorddibbATshawDOTca wrote:





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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben MS Excel MVP

On Fri, 18 Apr 2008 23:48:02 -0700 (PDT), Bassman wrote:
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- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

Any Ideas anyone?