need to create printable labels using macro

[sharondiana]

i need to create printable lables for my products from a list in excle .
From below two coloums


Sku PO Qty
Bracelets-BB003 6
Bracelets-BB004 8
Bracelets-BB029 5
Bracelets-BB061 8
Bracelets-BB063 3






i need to run a macro which gives the below format


Bracelets-BB003 Bracelets-BB003
6 6

Bracelets-BB003 Bracelets-BB003
6 6


Bracelets-BB003 Bracelets-BB003
6 6





These will be printed in A4 sheet accomadationg 16 lables per sheet


Please help me with these.

 

[nardagus]

Why won't you use word's Mail Merge?
In word you will have a template while in excel you will have label data.

Nard