Macro to print label sticker

[erosche]

I need to do a print out a label on 4" x 6" sticker.

Attached the excel for reference on the data to print and also the layout to print
The No. of CTN/Label is the number of copies for the label.
Eg. Store name : B Golden Grove, Store Number : 5305, Region Code = V, No. of CTN/Label : 3, means need to print out 3 sticker

Could anyone help to write a macro from the data {Store Name} , {Region Code} and {Store Number} that retrieve from excel sheet ?

Thanks a lot

[arthurbr]

Why reinvent the wheel?

Have you had a look at printing labels possibilities with MS Word? It works beautifully providing you know the sticker type or measurement

See Tools - Letters and Mailings- Envelopes and labels

[erosche]

Hi, I try to use Mail Merge in Microsoft Word actually, but it cannot automatic the no of copies to print sticker label according to the information of "No. of CTN/Label".

Please advise how to make automatic for no. of copies to print. Because we have many records to print and each record has different no. of copies.

Thanks.