Mail Merge From Excel To Word Labels 

If you need to send a mass mailing to your address list, you can use a Microsoft Word document that has the mail merge from excel to word labels feature.

  • 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.

Address Block:

Mention the name format of the recipient, company name, and postal address.Mention the name format of the recipient, company name, and postal address.

Insert Merge Field:

  • Step 1: Fill the First Name, Last Name, and Street Address fields.
  • Step 2: If needed, add a greeting line.
  • Step 3: Check if the Mailings tab is clicked. Select the Update Labels option.
  • Step 4: If you want to preview the result, select the Preview Results option.
  • Step 5: Go to the Mailings tab, navigate to the Finish & Merge drop-down menu, and select the Print Documents option.
  • Step 6: If you want to edit the document before printing, choose the Edit Individual Documents option from the Finish & Merge drop-down list and creating the mail merge from excel to word labels.
Need Technical Assistant?