![]() This free Word template allows you to easily create as many labels as you need for a specific purpose.Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting ( ). Of course, there are third-party solutions that are available for creating sequentially numbered labels. You should now have a document that has all your labels in it, and you can print them as desired. Merge the information to a new document.Make sure the label contents are formatted the way you need them. Create the sample label so that it has the word Exhibit followed by a merge field that represents the number being pulled from the Excel worksheet.Go through the steps of creating a new document consisting of labels and specifying your data source (the worksheet you created in step 1).This displays the Mail Merge Helper dialog box. In Word, choose Mail Merge from the Tools menu.For instance, if you need 175 labels, you would place a title in cell A1 (such as "Number") and the 175 numbers you need in cells A2 through A176. Create an Excel worksheet that has as many numbers in it as you need. ![]() Conceptually, you only need to do the following: If you prefer to not use the SEQ field to create the labels, you can also create them doing a mail merge. All your numbering should now be correct. This updates all the fields in what you selected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |