Taking an excel userform textbox values and applying them to a label printed in Microsoft Word

[Pookiemeister]

My company used to use printed sheets of paper with the product information which was then tape to the pallet of finished goods all this was done with an excel userform. Now they have gone to adhesive labels printed from Microsoft Word. Since I am not familiar with VBA within Microsoft Word, I am not sure how I can achieve the same thing. The new labels are manually typed in. The setup of the adhesive label is as follows:

1. Top left corner contains a value in Calibri Font; Size:9
2. Top right corner contains a value in Calibri Font; Size:9
3. Bottom left corner contains a value in Calibri Font; Size:9
4. Bottom right corner contains a value in Calibri Font; Size:9
5. The center of the label contains the pallet number in Calibri Font; Size:12

So to paraphrase how do I go about taking the values from an excel userform and placing those values in specific spots on a label using VBA code. I hope this explanation makes sense.

Thank You

 

[sykes]

Assuming all of the data's contained in a spreadsheet, it seems the simplest way to achieve this would be to make the Word label a MailMerge one, then just use the fields to populate the label.