how to mail merge labels from excel to word using wizard

Select the Excel source workbook containing the data set with names and addresses.You'll be prompted to specify the type and / or size of labels you want to generate. In Word, start the merge and specify the main document for labels.There are 8 steps in the Word mail merge process for mailing or address labels: Recommended article: How to Use Mail Merge in Word for Form Lettersĭo you want to learn more about Word? Check out our virtual classroom or live classroom Word courses > Understanding the label mail merge process in Word Address labels are often called mailing labels or shipping labels.

Typically, labels are purchased in sheets that you place in the tray or document feeder of your printer and a product code is printed on the label packaging. When you run the mail merge, you can create a new merged file with a label for each contact or merge directly to a printer. You'll need to create a main document for the labels in Word and then connect to a data set or list in an Excel worksheet (although you can use other data sources). This is typically used to generate and print bulk mailing labels for names and addresses of clients or other contacts. You can create labels in Microsoft Word by running a mail merge and using data in Excel.

If everything fits, you start the label merge.Create and Print Labels in Microsoft Word Using Mail Merge and an Excel List (Generate Bulk Address or Mailing Labels)īy Avantix Learning Team | Updated January 9, 2021Īpplies to: Microsoft ® Word ® 2013, 2016, 2019 and 365 (Windows)

Finally, arrange the data fields as you want to be printed later.

You only have to enter what data fields to your mail merge labels applied. Alternatively, you can also use your Access database use. This is the created Excel address database.

After you have set up the appropriate label format, select in the next step, your data source.

In the menu In the 'label options', select your label type.

Then click on the 'documents change layout' and then 'labels' option.

You only need to follow very conveniently for the individual steps.

Once you have accessed the mail merge wizard, you can see the menu of the wizard on the right side of the screen.

In the Pull-Down menu, you will see the 'mail merge wizard'.

In the ribbon, go to the 'start mail merge' and click on the namesake Icon.

To work with the mail merge wizard, first go to the tab 'broadcasts'.

How to mail merge labels from excel to word using wizard