how to do a mail merge in excel for labels

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 do a mail merge in excel for labels