Create a mail merge with half an Excel worksheet

When using a Microsoft Excel sheet as the basis for a mail merge it is possible to use a section of a worksheet, rather than the whole sheet.

Select the range you want to use in Excel and look for the text box underneath the File menu that shows the cells selected. When the selection is correct, left-click in this box and type a name for the range such as ‘addresses’.

Save the spreadsheet then return to Word. Click on the Tools menu, Letters and Mailing and then on Mail Merge. Follow the wizard that appears in the Task bar and click on Browse at step 3 and select the spreadsheet.

The window that appears will now include the named range as well as the worksheets. Click on the name of the appropriate range and then on OK. Continue the mail merge wizard as normal and it will use this specific range.