Importing data from an excel table to populate a multi-purpose label template in word?

[dougmarkham]

Hi Folks,

I have excel data---columns A and B---populated by 3 digit numbers

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]278[/TD]
[TD="align: center"]192[/TD]
[/TR]
[TR]
[TD="align: center"]148[/TD]
[TD="align: center"]112[/TD]
[/TR]
[TR]
[TD="align: center"]168[/TD]
[TD="align: center"]325[/TD]
[/TR]
[TR]
[TD="align: center"]279[/TD]
[TD="align: center"]261[/TD]
[/TR]
[TR]
[TD="align: center"]306[/TD]
[TD="align: center"]38[/TD]
[/TR]
[TR]
[TD="align: center"]292[/TD]
[TD="align: center"]259[/TD]
[/TR]
[TR]
[TD="align: center"]135[/TD]
[TD="align: center"]654[/TD]
[/TR]
</tbody>[/TABLE]

There are a few thousand lines of these numbers.

I would like to import these numbers (one number per label in the same layout as the table e.g., col A in left 7 labels, col B in right 7 labels) into a Microsoft word label template (eu30011) which fits the Q-Connect Multi-Purpose label (KF26054).
This label has the following properties:
Paper size: A4 (210 mm x 292 mm)
Label size: length (99.1mm) x height (38.1mm)
No of labels per page: 14 (7 in col A, 7 in col B).

https://www.aosonline.co.uk/q-conne...m-14-per-a4-sheet-pk-100-white?search=KF26054

Is there a way I can import the excel data into Microsoft word 2013 to populate this template automatically i.e., either with some sort of excel / word functionality or via VBA?

Would anybody be willing to help me in the regard please?

Kind regards,

Doug.