How To Create Mail Merge From Excel To Word Labels In Simply?

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.

How to Setup Mail Forwarding

How to Stop Mail Forwarding