Microsoft Access Question about Report

[akapaulk]

So I have a database setup along with a very neat form. I will be inputing information into the database using the forum after a customer's visit with the following information (customer name, job date, scheduled time, actual arrival time, job completion, total time, hours billed, etc).

I have everything set towards my highest satisfaction up to this point. What has been frustrating me for the past 2 hours is trying to figure out how I can do the following:

a) I want to be able to export ONE CHOSEN record into an email attachment as opposed to attaching ALL records.

Can someone please advise?

Cheers!

 

[akapaulk]

In Microsoft Works all you have to do is CHECKBOX a record and do a mail merge. Very simple. I'm sure there's an easy solution that I'm missing