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".
