Excel to Word Using Mail Merge

[Jacqueline]

Hi, I have a few problems when using Mail Merge to open Word from Excel. As I am unable to automate the process and save the format I use for the labels, I need to select the format after every use.

I have an Excel worksheet filled with shipping details that I need to format into labels.

I want to write a code for the following:
1. Have a button in excel where it will automatically generate the shipping labels through mail merge
2. Ensure that the format of the shipping labels are identical to the preset formatting (E.g. size and alignment)

I have attached the excel and word.

Courier's Template.xlsm



Label Format.docx