how to convert excel file to word labels

In this step, we will connect our Word file with an Excel worksheet. To merge excel files to mailing labels we need to link our work file with an excel worksheet. Step–3: Link Word File and Excel Worksheet to Merge Mailing Labels Read More: Macro to Populate a Mail Merge Document from Excel

Then, click on the option ‘ Next: Select recipients’ at the bottom.

Furthermore, from the new pane check the option ‘ Use the current document’.

The above command will take us to a new Mail Merge pane.

Moreover, click on the option ‘ Next: Starting document’ at the bottom.

After that, from the ‘ Select Document Type’ section check the option Labels.

The above action will open a mail merge pane.

In addition, from the drop-down menu select the option ‘ Step-by-Step Mail Merge Wizard’.

Then, from the ribbon select ‘ Start Mail Merge’.

First, create a new document in Microsoft Word or open an existing one.

In the second step, we will merge an excel file to mailing labels by placing mail merge documents in Microsoft Word. Step-2: Place Mail Merge Document in Microsoft Word

Read More: How to Mail Merge from Excel to Outlook (with Easy Steps)

Furthermore, select the same names for your column headings as those in the ‘Required for Address Block‘ section.

Notice the terms in the ‘ Required for Address Block’ section such as First Name, Middle Name, Last Name, etc.

Next, before approaching the next step we need to ensure some important things.

So, when we will merge excel files to mailing labels, the column headers of our Excel sheet will convert into mail merge fields in a Word document.

We’ve taken the First Name, Last Name, Address, and Country of five presidents to create the following dataset.

First and foremost, create an excel sheet like the following image.

So, to make you understand this method better, we’ll demonstrate the process to you in 8 steps. The entire process to merge an excel file to mailing labels with the help of Microsoft Word is simple but a little bit lengthy. Required Steps to Merge Excel Files to Mailing Labels Combine Excel Sheet to Mailing Labels.xlsx

How to convert excel file to word labels