Macropod,
Thanks very much for your interest and help!
Unfortunately I am having problems with your code because 1Col takes on the value of a 13 digit barcode (in the last column of the table).
However A thought triggered by your code led me to the idea of using a table consisting solely of a column of the required number of repetitions of the needed barcode.
As a data source for a manual mail merge ,this works.
I find I have still another problem though, which is how to automate the mail merge in Word.
I can create code by recording a macro, but I cant find a way of triggering this code from Excel or even from within Word. If I manually open the Word document containing the code I get the message to confirm the data source but nothing further happens until I go through the merge manually.
Can you help me further? Ideally, I want to have my user open the excel Workbook
choose the bar code and the number of labels required(this I have successfuly coded), then move seamlessly from Excel into the Word document and complete the label printing.
John