Word Mail Merge Labels From Excel How To Prepare Your

You will learn how to prepare your Excel address list for mail merge, set up the Word document, make custom labels, print them and save the file for later use.

Today lets see how you can leverage this feature to mail merge and print labels from Excels address list.

Whatever intricate and intimidating the task may sound, it actually boils down to 7 basic steps.

Each placeholder corresponds to one entry such as first name, last name, salutation, city etc.

This will make it easier for you to arrange, review and print your mailing labels in Word and you save more time in the long run.

For example, youd better create 3 separate columns for titles, first names and last names rather than a single Name column.

This will ensure that all leading zeros in your postal codes will remain intact.

You will find the detailed guidance in this article - How to import CSV to Excel.

Note that neither spaces nor hyphens between words are allowed, you can use an underscore instead.

The good news is that you have to do this only once for all the labels in the mail merge.

You can also choose some other content (text or graphics) to include in each label, e.g.

It provides the step-by-step guidance which may be helpful for beginners.

If you are pretty comfortable with the mail merge feature or prefer working with the ribbon, you can proceed in this way.

We will be using the step-by-step wizard in this tutorial to make the learning curve easier.

The currently opened document will become your label main document.

The Mail Merge pane will open in the right part of the screen.

Otherwise, select the whole table, you will be able to refine, sort or filter the recipients to include in the mail merge later.

The first click sorts in ascending order, the second - in descending.

You can also filter the list by some other information such as country or state.

The last option is available if you have any validation software installed.

When you perform the label mail merge, the placeholders will be replaced with the information from your Excels address list.

Word For Mac Mail Merge Labels From Excel