We need to create mailing labels in our practical life almost everyday. 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
Download Practice Workbook
7 Steps to Create Mailing Labels in Excel
We need to follow the steps below to create mailing labels in Excel.
Step 01: Prepare Address List
We’ll first make our dataset named as 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 informations like this.
Secondly, go to Formulas > select Define Name from the Define Names group.
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.
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.
Secondly, go to Mailings > select Start Mail Merge > select Step-by-Step Mail Merge Wizard.
The Mail Merge bar will now appear on the right side of the screen.
Thirdly, choose Labels and then choose Next: Starting Document.
Fourthly, select Change document layout in the Select starting document option.
Fifthly, we will then select Label Options.
Sixthly, in the Label Options dialogue, we will select the options like shown below.
After that, click Details.
Seventhly, format labels next as needed.
After that, click OK and we’ll return to the Mail Merge window. Then click Next: Select recipients.
Read More: How to Create Labels in Word from Excel List (Step-by-Step Guideline)
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.
We’ll select our Excel worksheet like this and click Open.
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.
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.
We will click Next: Arrange your labels in the Mail Merge window.
Step 05: Arrange Address Labels
In this step, firstly, select the Address block from the Mail Merge window.
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.
After finishing, click OK and in the Mail Merge window we need to click on
Next: Preview your labels.
Read More: How to Print Address Labels in Excel (2 Quick Ways)
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.
Highlight the preview and select the Home tab when we need to make the changes to the font type, color or size.
When we are satisfied, we will select Next: Complete the merge.
Read More: How to Print Labels in Excel (With Easy Steps)
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.
Read More: How to Mail Merge Labels from Excel to Word (With Easy Steps)
If you study this article properly, it will help you to create any kinds of mailing labels in Excel effectively. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.