This article will explain how to create a mail merge and print onto labels.
Step 1: Populate an excel spreadsheet with the correct information under the correct headings as seen below.
Step 2: Open a blank word document and navigate to the "Mailings" tab as shown below.
Step 3: Navigate to the "Start Mail Merge" button and choose "Labels" as shown below.
Step 4: Choose your "Label Vendor", this will most likely be "Avery A4 and your "Product Number". This info can be found on the packaging of your labels.
Step 5: A layout will be highlighted as seen below.
Step 6: Navigate to the "Home" tab and select the "Boarders" button and then choose "All Boarders" as shown below.
Step 7: Below is the result of adding the borders, it is important to reverse this step before you print your labels as it will print the borders aswell.
Step 8: Navigate back to "Mailings", choose "Select Recipients", "Use an Existing List". See below.
Step 9: Find and import and open the excel document you generated at the start of this process.
Step 10: Choose "Create a local copy and merge your changes later" then press "Ok".
Step 11: Should the below message open, simply press "Ok"
Step 12: Select the first box in the grid. Under "Mailings" find "Insert Mail Fied", click on the fields listed 1 by 1 to insert them into the post. Think about your formatting here. See below.
Step 13: Below shows the field inserted onto separate lines. This was achieved by inserting each field 1 by 1 whilst pressing enter in between to start a new line.
Step 14: At this point, you want to go back and remove the borders you added before. Do the reverse process however instead of choosing "All Borders! choose "No Borders". Then navigate back to "Mailings", choose "Finish & Merge", "Print Documents".
Step 15: Make sure "All" is selected and press "Ok". The mail merge will now print.