Label wizard word update#
Label wizard word code#

See Figure 9.Ĭlick the Preview Results button (see Figure 11) on the Mailings tab to check your labels for accuracy before completing the merge.

Label wizard word update#

To update all of the labels to match the address block design of the first label, click the Update Label button on the Mailing tab.

Label wizard word code#

You will see the code > in the first address label’s spot. If you are using international addresses, you will want to check box to format the addresses according to their destination country or region. Note: if your field names do not match what Word mail merge is looking for, you may need to click on the Match Fields button and correctly link the fields.

In the Insert Address dialog box, choose the name, address, and city/state/zip arrangement that you would like for your labels. Click on the Address Block button (See Figure 6) on the Mailings tab to pick the layout of your address. You will get one set up and then the rest of the labels will follow the same format. Next, you want to create the label itself. When you have the file and worksheet selected, your first three lines of your document will now look like Figure 5. If you are using an Access or other database, you will need to choose the table you want to import. If you are using an Excel file, you will need to choose the exact worksheet on the next screen. When you choose to Use an Existing List, navigate to the location of your file and choose it. The Excel file has a column for First Name, Last Name, Address, City, State, and Zip. For this example, I’ll choose an Excel file. You can choose from your Outlook contacts, an Excel file, a database file, or even type in your own list. On the Mailings tab, click on the Select Recipients button. You will need to choose your recipients before you can set up the labels. Once you have turned on your non-printing characters in the step above, you can see your labels more clearly. Click on the home tab and on the show/hide button in the paragraph group. Turn on the show/hide characters to help you see the label edges. Your Word document will look about the same but it is already set up and formatted for the labels. For this example, we will choose a standard size label that is available for purchase in most office stores and online. There are address labels, filing labels, multimedia labels, and much more. On the label options dialog box, you can choose from a large variety of labels. Click on the Mailings tab and click the Start Mail Merge button. This will be your main document for the merge. Open a blank Word document and save it to your computer.

For small and large businesses, creating labels can be a big time-saver. One of the best ways to start out with mail merge is to create basic mailing labels. Usually when I go through the steps with them, they realize it is much easier than it seems. In my past training classes, I have encountered many students who think it is too complicated since it involves several steps. If you are not using the mail merge feature, then you are missing out on a great tool. As I was getting my holiday cards ready to send recently, I realized again how useful mail merge was to create labels in Microsoft Word.