How to email a single record from a form in Access?

Create a query that will extract the records your manager needs using the criteria rrequired. For EXAMPLE: if you have a table listing cars bought in 25 cities and your manager only needs to see info about cars bought in 3 of them, then your query would extract only those three. Then you create a report using this query and then you can export the report in Excel, Word, PDF, HTML, Text or snapshot viewer format and either one of these can be sent in email. And which format you use is really up to you.