How To Mail Merge Labels From Excel

The Mail merge is the process of collecting data from different sources such as a database, spreadsheets, or other forms and inserting it in a letter, labels, and name tags format. Many applications offer the Mail Merge features. The Maestro Label Designer and Microsoft Word programs are the most used programs. The section below explains how to mail merge labels from Excel.

The Mail Merging Process Takes Place In Two Steps

  • Step 1: First, create the data list you wish to mail merge labels.
  • Step 2: Second, open the mail merge wizard and perform the merging process.

Steps To Create The Data List

  • Step 1: Launch the Microsoft Excel application on your Windows computer.
  • Step 2: Click the tabs or columns based on your data.
  • Step 3: Enter the required information or data in the given fields.
  • Step 4: Finally on using how to mail merge labels from excel guide, save it by clicking the File menu followed by Save.
  • Step 5: Make sure to select the correct format from the Save as type drop-down menu.
  • Step 6: Once you have created the data list correctly, you are ready to create the mail merge labels.

Launch The Mail Merge Wizard

For the Microsoft Word 2019/ Office 365 Mail merge users:

  • Step 1: On the Microsoft Word 2019 or Office 365 application, locate and click the Mailing tab.
  • Step 2: Select Start Mail Merge > Step-by-Step Mail Merge Wizard > Change document layout > Label options.
  • Step 3: From the second drop-down list, select the OnlineLabels.com option.
  • Step 4: Choose your label from the suggested list and click the OK button.
  • Step 5: To view the outline of the labels, click the Layout tab and choose the View gridlines option.
  • Step 6: Click the Next: Select recipients option.
  • Step 7: Make sure to select the Use an existing list option.
  • Step 8: Open the data set you have created.
  • Step 9: Click the Arrange your labels option and proceed with how to mail merge labels from excel guide.
  • Step 10: If you wish to create address labels, then click the Address block tab and perform the instructions displayed on the screen.
  • Step 11: Finally, click the Update all labels button.
  • Step 12: Now, all the data will be inserted correctly in the respective columns.
  • Step 13: Click the Next: Complete the merge option.
  • Step 14: Close the Mail Merge wizard.
  • Step 15: Make sure to save the document.

You can also print the created mail merge labels. To do it, follow the instructions given below.

  • Step 1: First, get the printer that supports label printing.
  • Step 2: Set up the printer as per the instructions.
  • Step 3: Make sure to fill the mailing labels into the printer.
  • Step 4: On your Windows computer, open the mail merge labels that you have created.
  • Step 5: On finishing how to mail merge labels from excel guide, Click the File menu followed by Print.