Mail Merge - Using Excel & Word, how to select specific criteria ?

[PurrSent]

Windows 10 - v 22H2 64-Bit
MS Excel & Word 2019

Hi Folks

I have been sent an Excel file, containing name, address, postcode of a number of people.

I want to print address labels from this data. However, there is one column, named 'Raffle', which has either a 'Y', 'N' entered, or left blank (to be considered as 'N', for this purpose)

My issue is how do I select only the data with 'Y' in 'Raffle' to print address labels, please? Is this complicated, or even possible, please? I will then need to print a separate 'pile' of address labels for those with the 'N' or Blank in the Raffle column, ie all that doesn't have 'Y'.

I'm able to do this, easily, from Access Db but have never done this from Excel. I'm wondering if it's going to be easier for me to just do this from Access, changing the query criteria to 'Y' or 'Not Y'. I will have to do this about 3 times a year so, if it's easier, and quicker, to do this in Excel, I'd like to learn. If easier procedure in Access, then I can Import the Excel worksheet, of course, and run the Query, which I can alter as required.

I'm hoping someone can advise me, please? Thanks very much for all your time, trouble, knowlege & experience

 

[Fluff]

Duplicate to: Mail Merge - Address Labels, from Excel, selecting specific criteria, please?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.