Merge excel with word for labels
![merge excel with word for labels merge excel with word for labels](http://www.help.narrative1.com/_/rsrc/1472690587122/merge-excel-word/Word03MenuMerge.jpg)
![merge excel with word for labels merge excel with word for labels](https://www.howtogeek.com/wp-content/uploads/2019/05/Finished-merge.png)
Under “Printer Information” select “Page printers” and under “Label information” select “Avery US Letter,” and finally, under “Product number” you need to find the size of the labels you will be using for the mail merge.Open Microsoft Word 2007 and go to Mailings>Start Mail Merge>Labels, and the “Label Options” pop up window box will appear.
![merge excel with word for labels merge excel with word for labels](https://i.ytimg.com/vi/l3pfc6W0LJg/maxresdefault.jpg)
#MERGE EXCEL WITH WORD FOR LABELS HOW TO#
In this tutorial, I will show you how to create a mailing label merge using Excel and Word, so that you can mail out your wonderful created letters from the successful mail merge in the previous tutorial. At the bottom of each label there is plenty of empty space which I would like to use. Since you probably have learned by now how to do a mail merge with Excel and Word, how about I show you how you can use the same principles and create a mailing label mail merge using both Excel and Word.