Does it can do by excel?

[QT]

hi all,

i need to print some label, but the label just a little bit difference from
each other.
Follwing is the template.

Box1:
Product Name: ABCxxx
Customer Name: ABCD company
QTY: 30
Cnt: 1 of 30

Box2:
Product Name: ABCxxx
Customer Name: ABCD company
QTY: 30
Cnt: 2 of 30

and box3 and so on are just change the Cnt: number of 30.
I don't want to make every label by copy and just change the Cnt value, it
really waste time for the quantity is very large.
So i want to know does excel can do with just one template and the value
will change automatically during printing the label.
If it can, how to do this? Thanks.

 

[Bernard Liengme]

For help on Word mail merge using Excel as the data source have a look here

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.
best wishes