how to mail merge labels from excel to word 2013 youtube

(called catalog in some earlier versions), e-mail and envelope merges. Word also provides form letter, directory Simply because they are the most complex.

Create the merge layout documentĪlthough this page is primarily concerned with label merges, there is no essential differenceīetween the different types of merge available from Word. Methods of working and move on to the merge process. So while you can still use old and familiar tools, you may as well get used to learning the new In fairness to Microsoft, the new ribbon commands do tend to make the merge process simpler, However the old Word 2000 Mail Merge Helper is still buried in the applicationĬode and can be added to the QAT (Quick Access Toolbar) to provide the old familiar dialogįor those Luddites not yet ready to move on. To the apparent complexity of Word 2002/3 now have an all new set of dialogs to achieve If you use a different number, such as 7, which is not evenly divisible (7 times 4 is 28, which is the closest you can get), then you must remove all the fields from the last two labels of the sheet so they will print out blank.Those who struggled to adapt from the relatively straightforward merge process in Word 2000 For instance, you could print 2, 3, 5, 6, 10, or 15 labels and fill up each sheet. In the case of the Avery 5160 labels, the number 30 (the number of labels per sheet) must be evenly divisible by the number of copies you want. The downside to this approach is that the number of labels you print must be a factor of the number of labels on the sheet. You will see that for each label except the first one, Word includes a should appear only at the beginning of the sixth, eleventh, sixteenth, twenty-first, and twenty-sixth labels. If you display the source document and then press Alt+F9 to display the field codes in the document.

The answer lies in going back to the source document-the one with the field codes-created by Word. However, if you wanted to print five copies of the same label, in order, on the first sheet, then five copies of the next label, in order, you can't use the approach of simply printing the merged document multiple times. The first label in each set is the same, as you would expect. For instance, let's say that you wanted five copies of each label, so you printed the merged document five times. The problem with this approach, of course, is that you end up with multiple sets of labels, not multiple label copies. This merged document can be printed as many times as desired to achieve all the copies you want. To print multiple copies of labels, all you need to do is merge the source document with the data source to create a new document.

When you use Word's mail-merge feature to create labels, it simply creates a source document that contains the proper field codes to print a single set of labels.

How to mail merge labels from excel to word 2013 youtube