Select which rows of a database to print as labels

The database program in MS Works allows rows to be selected, from which labels will be printed. How in LibreOffice can one choose which rows will be used for printing labels and which skipped?

The Mail Merge dialog you arrive at when you are ready to print labels offers these options to select the labels to be printed:

  • Use a query that just gives the labels you want as your data source
  • Select a range of records to use, either by number or by control-clicking the record selectors in the field grid.
  • Use the standard filter to define criteria to use

A good answer if you already know what all the terms mean and how to find the functions mentioned. Lacking this knowledge, it took me some time to find a working solution. I will continue to explore database operations.