Now, a new pane appears named Merge to New Document.On the dropdown that appeared, click and select Edit Individual Documents.Click on it to see the different options available. On the rightmost side of the Mailings pane, you can see a dropdown called Finish & Merge.
After this step, you will see the mailing labels on a new word sheet and print them. We are almost done and up-to-the final step of printing named labels for our mailing list.
Select > Options (placed at the bottom of the left pane). Basically, this step helps to have a smooth conversion between Word and Excel. It is mandatory to set some file format settings under Microsoft Word so that you can use the excel file in it. Step #2 – Confirm File Format in Microsoft WordĪs I have mentioned earlier, we are going to use an Excel file in Word. Save the file once you are done with entering the data and close the same.
It helps to manage and print labels properly. As shown in the screenshot, your details should be one entry per column.
Salutation, First Name, Last Name, Address, City, State, Postal Code these should be the columns, and respective information should be filled in those columns. As we want to create mailing labels, make sure each column is dedicated to each label.
You can download this How to Print Labels From Excel Template here – How to Print Labels From Excel Template Step #1 – Add Data into Excel