Mail merge between excel and word

I would have a summary table in Excel that pulls data for new joiners only, then create a new joiners' mail merge based on this table instead of the full table.

The summary table can be created with Office 365 formule or PowerQuery - attach a sample file if you want exact details.

You can use the full table and simply apply a mailmerge filter to exclude dates prior to the ones you're interested in. You can do that via Mailings|Edit Recipient List>Filters.

Paul - not sure it's as simple as dates, but if there's a column to indicate new joiners, then that could be used instead.

Well, the OP does say:

Originally Posted by OldBoy

I have a data sheet that is growing all the time (new joiners), with new dates being added to the sheet (their start dates). I want to do a mail merge so that word pulls certain data from the excel sheet BUT! I want the mail merge to only pull data from dates I select, so that it only populates new joiner info from certain dates.