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, therefore I need to select the format after every use.
As 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. The paragraphing and alignment of the shipping details)
I have uploaded the excel and word into this link: Box
As 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. The paragraphing and alignment of the shipping details)
I have uploaded the excel and word into this link: Box