Or, right-click the field and choose Update Field. Position the cursor anywhere in this field and press the function key to update it. Then choose the type of document to merge and select OK to complete the merge. Choose whether to use all contact fields or only those fields in the view. Then you can go back to the mail merge file and send out the messages. These instructions apply to Excel and Word 2019, 2016, and 2013 and Excel and Word for Microsoft 365. This guide explains how to create and print labels from Excel using the mail merge feature in Microsoft Word. To add mail merge fields in Word, go to the Mailings tab and, in the Write & Insert Fields section, add fields in the Address Block. You can either copy all the relevant data into a single worksheet or you can use SQL to create a query that will present the data in a table-like manner. If your data is spread across various worksheets, you will need to get them into a singe source.
Mail Merge needs a single table such as a worksheet for the input data.
