- Step 1: Create a Microsoft Excel spreadsheet and then use the Microsoft Word document to customize and organize.
- Step 2: Once done with creating the Microsoft Excel spreadsheet, refer to the easy steps mentioned below to print labels for your mailing list.
- Step 3: After you click the Mailing tab on the Microsoft Word document, choose the Start Mail Merge option followed by the Labels option.
- Step 4: When you see the Label Options dialog box on the screen, select your label from the Label Vendors list.
- Step 5: Go to the Product Number list and choose your product number of labels.
- Step 6: After clicking the OK option, you will see a table that contains an outline of the label.
- Step 7: If you do not see the table, click the Table Layout tab and choose the View Gridlines option.
- Step 8: Save the document by clicking the Save option from the File menu.
- Step 9: Select your recipient by choosing the Select Recipients option.
- Step 10: Once you have clicked the OK option, navigate to the Mailings tab and select either the Address Block or Insert Merge Field option to create the mail merge from excel to word labels.