Save your workbook (Addresses.xlsx) and you are now ready for the mail merge.Using the arrow handle in the lower right corner of the table, resize it to just include your addresses. The Table will need to be resized to exclude the blank rows.Select the records that are unconfirmed and cut and paste them to the new worksheet below the headers.Select the table headers and copy and paste to a new worksheet (I named the sheet “NeedAddresses”).
The next step is to cut and paste the unconfirmed addresses to another sheet in the workbook Here is what the sorted table looks like:
When a name is defined for a Table in a worksheet, the name will update automatically as the table is resized to add or remove data.
The first step is to create a Table from the list of addresses.