How to email a record in a access table.

[Beamer2010]

I have been working on this for ever. I have a table and I would like to send email of just the selected rows. I end up sending the whole table. Is there a way to recognize only the rows that are selected? Also, these rows will vary from time to time so it is not a fix range. Thank you for all of your help.

 

[alansidman]

Create a query and then email that. The query will filter your table based upon your criteria.