Mailing list from select addresses

[Tuckejam]

I know there are about a dozen different ways to do this, but I'm curious what the proper way to do it would be (as well as the best/proper quick fix way)




I have tbl_houses it has house name, address, city, etc, phone, email address etc.

tbl_houses has 80 records

I need to mail something to 35 of the houses.

now I know step one is creating a qry that only has the name, address, city, state, and zip (then MS Word can use this qry to Mail Merge and print envelopes)

BUT!! how do I get the only the 35 houses that I need? there is no way to filter the data to get to this set of houses (some houses applied for the rent relief and some did not)


i don't want to type 35 house names into the criteria in the qry, and I don't think it wise to add an additional "selection" feild to the tbl_houses


anyway, any thoughts on the process here would be appreciated


Thanks

[June7]

There must be some data to base selection on, to filter records.

Otherwise, select each house individually from a multi-select listbox and loop through listbox selection to send emails.