Site icon ExcelNotes

How to Create Labels in Word

You can create multiple labels from a database that contains names and addresses. If you need labels for one name, simply copy the records to many rows. Please see the steps below:

Step 1: Open a blank word document;

Step 2: Click the "Mailings" tab from the ribbon;

Step 3: Click "Start Mail Merge" and select "Labels…" from the drop-down list;

Step 4: In the "Label Options", select "Label information" (e.g., Microsoft) and "Product number" (e.g., 30 per page);

Step 5: Click "OK". You will see the page margins become narrower in this example.

To Select Recipients

Step 6: Click "Select Recipients" from the "Mailings" tab, and select "Use an Existing List";

Step 7: Select the Excel file containing your contacts and click "Open";

Step 8: In the "Select Table" dialogue box, select the Worksheet with recipients and click "OK";

If your data has column headings, check the box of "First row of data contains column headers".

Step 9: Now "«Next Record»" will appear on the page.

To Edit Recipient List

Step 10: Click "Edit Recipient List" from the "Start Mail Merge" group;

Step 11: By default, all recipients are selected. Please un-check any recipients that you do not want to include and click "OK";

Step 12: Move the cursor to the beginning and click "Address Block" in the "Mailings" tab;

Step 13: Select the name format and click "Match Fields" in the new window;

Step 14: Select the proper data from the drop-down in each box and click "OK";

Step 15: Click "Update Labels" from the "Mailings" tab, and you will see «AddressBlock» appear in each block;

To Preview and Finish

Step 16: Click "Preview Results" from the "Preview Results" group under the "Mailings" tab;

Step 17: Scroll up and down till you are satisfied with the results;

Step 18: Once you are satisfied with the labels, under the "Mailings" tab, click "Finish & Merge" from the "Finish" group;

Step 19: To edit each label individually, select "Edit Individual Documents", or to print all the labels by clicking "Print Documents".

Exit mobile version