In this article we will show you the solution of how to mail merge labels from excel to word 2016, Microsoft word and Microsoft Excel are both very powerful and most used software application.

Excel is used extensively in finance and accounting, in fact many business organizations run their entire accounting, budgeting and forecasting functions with the help of Excel spreadsheets.

People like accountants, bankers, analysts as well as educational institution, small start ups, governmental organization use Microsoft excel to keep tab of every kind data.

Microsoft word is most commonly used word processor software. Now best part about these applications are, user can use same document in multiple application as different format. This feature is called mail merge.

Mail merge is a procedure which enables user to combine a data file with document.

With Mail Merge we can incorporate data both from Word and Excel. For example, a list of individual name and addresses, this way copies of the document are different for each person.

We can do mail merge by following few steps.

Step By Step Guide On How To Mail Merge Labels From Excel To Word 2016 :-

1. Open a excel file.
2. Enter a format, for example SERIAL NO, NAME, AGE and GENDER
3. Put the details and data in the excel sheet.
4. 4.Click the top left corner.
5. Click save as button as excel workbook.
6. Then select the save folder location and save the file as excel workbook.
7. 7.Then open a new Microsoft word file
8. 8.Then click on mailing at the top toolbar
9. 9.Then click on start mail merge.
10. 10.Then click on labels
11. Then a new pop up window will open.
12. 12.Then select “ 30 per page “ from the product number and click OK.
13. Then click on select recipients at the top toolbar and click on use existing list.
14. Then select the saved excel file location where the previous excel file has been saved and click on ok button.
15. Then a new format will appear in the word document. Then click on insert merge field and select all the options such as SERIAL NO, NAME, AGE, GENDER.
16. Then click the right mouse button on the double arrow sign appearing in the screen and select border and shading.
17. click on ALL and press OK button , the below format will appear in the word document.
18. Then select the update labels options from the top toolbar
19. Then click on preview result on the top toolbar
20. Now click on top left corner to save the file and click save as word documents.
21. Then select the save folder location and save the file as word documents.

Conclusion :-

This is how mail merge labeling can be done. I hope this article on how to mail merge labels from excel to word 2016 helps you and the steps and method mentioned above are easy to follow and implement.