Navigate to the Excel file containing the names and addresses you want to use as the source.Click Use an Existing List from the drop-down menu.In the main Word document, click the Mailings tab in the Ribbon and then click Select Recipients in the Start Mail Merge group.To select a Microsoft Excel source file containing a worksheet with names and addresses for the labels: In the following Excel worksheet, note that the field names are in the first row of the sheet being used a source: Select Recipients appears on the Mailings tab in the Ribbon in the Start Mail Merge group as follows: There should be no blank rows in the data set. In the Excel worksheet, the first row must contain field names such as FirstName, LastName, Company, Address and so on. The next step is to connect to an Excel source file containing a list of names and addresses using Select Recipients. Step 2: Select the source Excel file containing the data set In the following example, Avery US letter was selected as the Label vendor with Avery 5163 address or shipping labels: If table gridlines are not displayed, click in the table and click the Table Tools Layout tab or Table Layout tab (on the right side of the Ribbon) and click View Gridlines in the Table Group.Next Record appears in each label cell to prompt Word to move to the next record in the data source. Word creates a table in the main document. You may also select New Label and then enter a custom name and size. #Avery label wizard word 2007 code#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |