How to Create Mailing Labels in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

We need to create mailing labels in our practical life almost every day. It becomes easier when we use Excel to do this because Excel offers very easy ways to create mailing labels within some moments. By studying how to create mailing labels in Excel, we can create mailing labels easily.


Watch Video – Create Mailing Labels in Excel


How to Create Mailing Labels in Excel: with Easy Steps

In this article, we will show you how to create mailing labels in Excel. To do this you need to follow the steps below to create mailing labels in Excel.


Step 01: Prepare Address List

We’ll first make our dataset named Mailing List of Citizens. This dataset has columns with headers as First name, Last Name, City, State, and Profession.

We will then fill up the columns with information like this.

how to create mailing labels in Excel

Secondly, go to Formulas > select Define Name from the Define Names group.

how to create mailing labels in Excel

A New Name bar will appear.

Thirdly, in the Name field, we will enter a name for our address list. Here it is MailingList.

Then, click OK.

how to create mailing labels in Excel

After that, we need to save our Excel worksheet.


Step 02: Set up Mail Merge Document in Word to Create Labels in Excel

Firstly,  we’ll start with a blank document in of the versions of Microsoft Word 2007, 2010, 2013, or 2016.

how to create mailing labels in Excel

Secondly, go to Mailings > select Start Mail Merge > select Step-by-Step Mail Merge Wizard.

how to create mailing labels in Excel

The Mail Merge bar will now appear on the right side of the screen.

how to create mailing labels in Excel

Thirdly, choose Labels and then choose Next: Starting Document.

how to create mailing labels in Excel

Fourthly, select Change document layout in the Select starting document option.

Fifthly, we will then select Label Options.

how to create mailing labels in Excel

Sixthly, in the Label Options dialogue, we will select the options like shown below.

After that, click Details.

how to create mailing labels in Excel

Seventhly, format labels next as needed.

how to create mailing labels in Excel

After that, click OK and we’ll return to the Mail Merge window. Then click Next: Select recipients.

how to create mailing labels in Excel

Read More: How to Create Labels in Word from Excel List


Step 03: Create Interlink Between Worksheet with Label to Create Labels in Excel

In this step, select Use an existing list under Select recipients.

After that, to find our Excel Worksheet click Browse.

how to create mailing labels in Excel

We’ll select our Excel worksheet like this and click Open.

select data source

A Select Table bar will appear.

Then, choose the Defined name which is MailingList here, mark the First row of data contains column headers, and click OK.

select table


Step 04: Add Recipients for Mail Merge to Create Labels in Excel

In this step, at first unmark any of the Data Sources in Mail Merge Recipients window which we don’t need to include in label. We will click OK after reviewing the list.

how to create mailing labels in Excel

We will click Next: Arrange your labels in the Mail Merge window.

arrange your label

Read More: How to Mail Merge Labels from Excel to Word


Step 05: Arrange Address Labels

In this step, firstly, select the Address block from the Mail Merge window.

address block

In the Insert Address Block dialog window, select any of the format in the Insert recipient’s name in this format option. After that, verify the outcome in the Preview section, and then click OK.

create labels

After finishing, click OK and in the Mail Merge window we need to click on

Next: Preview your labels.

preview your labels


Step 06: Preview Mailing Labels

Use the right or left-arrow buttons in the Mail Merge window to get a preview of the mailing labels. The preview of our Word document will appear like this.

preview

Highlight the preview and select the Home tab when we need to  make the changes to the font type, color or size.

create labels

When we are satisfied, we will select Next: Complete the merge.

Complete Merge


Step 07: Save Labels for Later Use

We can save labels so we can utilize them later. We have two choices for this function.

  • By clicking the Save button, we can save the Word document. The Mail Merge document will be saved in an as-is format and attached to the Excel Source By employing this structure, we will instantly reflect all upcoming updates to our Excel file in the Mail Merge.
  • By doing this, MS Word will ask us where we want to integrate the data from the Excel file when we Open the document the next time. To merge labels from Excel to Word, we will click Yes. Now, you know how to create mailing labels in Excel.

Download Practice Workbook


Conclusion

If you study this article properly, this article will show you how to create mailing labels in Excel effectively. Hope, you have found whatever you were looking for. Drop comments if you have any queries.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo