Forum Discussion
Mail merge excel data into template
Hello! I am trying to print out an Excel table by merging the data in the cells into a a template (Avery 5428, if that's helpful) and then printing the filled-in template. I have found tutorials whe...
Whoops sorry - I should have said 'cell B1 to go in the next template cell to the right.'
John_B42 The first row of your data source must be used for the field names. To achieve the output use describe, all of the data should be in column A, starting with cell A2, and in the first cell of the table in the Word document, you should insert the mergefield form cell A1 of the data source and then use the Update Labels button in the Write & Insert Fields section of the Mailings tab of the ribbon to replicate that set up to the other cells in the table.
