How to Mail Merge for Labels

Firstly, good luck. A ruler might also come in handy

Get the dimensions of the labels and the gaps between each label and the margin on the page.

Make a new word document with no data on it. This will be used for the Mail Merge

Create or download the Excel spreadsheet of data that you will be using for the Merge.

When you are ready, open the new Word document and click on the Mailings tab and then Start Mail Merge and choose the the Step-By-Step option:

In the "Mail Merge" sidebar, click on labels and then next.

If you have a template available then click on "Start from a template" otherwise, use the current document, wiping the document if necessary. Then click next.

Click use an existing list, then click Browse and find the file. Then click Next.

Enter the first label, then click on "Insert Merge Field" and enter each piece of information you need.

Edited to remove personal data

If you started with a template you should get the option in the Mail Merge Sidebar to "update all labels, basically taking the data from the first completed label and then copying this to all the other labels adding "<<Next Record>>" to the start meaning that each label will contain new information. 

Example:

All information above is a demonstration and not an actual student in the school at the making of this article.

Click next to see the preview and if everything looks alright, then click on Finsih and Merge at the top of the screen and print the labels.