If your company already has a package of label sheets from a certain manufacturer, e.g. In Microsoft Word, create a new document or open an existing one. Not to mislead you, this information will be provided in (brackets). Also, we'll point out where to find the equivalent options on the ribbon. To show you an end-to-end process, we are going to mail merge address labels using the step-by-step wizard. If you are pretty comfortable with the mail merge feature, you can use the individual options on the ribbon. It provides step-by-step guidance which may be helpful for beginners. There are two ways to do a mail merge in Word: The good news is that it's a one-time setup - all labels will be created in one go. With the Excel mailing list ready, the next step is to configure the main mail merge document in Word.
Giving identical names to your Excel column will help Mail Merge to automatically match the fields and save you the trouble of mapping the columns manually. The screenshot below shows a list of the Address block fields used by Word.
For address fields, use the full words such as Address, City, State, Postal or Zip code, Country or Region.
Today let's see how you can leverage this feature to make and print labels from an Excel spreadsheet. Last week we started to look into the capabilities of Word Mail Merge. You will learn how to prepare your Excel address list, set up a Word document, make custom labels, print them and save for later use. The tutorial explains how to do a mail merge from an Excel spreadsheet for labels.