How to code a button to EMAIL data?

[Ron]

HI,
I want to code a button on the form to email to a specific email
address.

For example I have a button called EMAIL GRADES and I want to basically
email my enroll table.

The enroll table looks like this:
STUDENTID SCHEDULENO GRADE
=============================
1112223333 9992211550 A
3321502510 9955210011 A
3321502510 9927750011 B

And when I press that button EMAIL GRADES I want to email those
headings along with the info under them to a specific address, lets say
(e-mail address removed)

can this be done? and how?

 

[Ron]

Or I guess it would be better to put the email code in the button that
is pushed when all grades are entered, here is what I have for that
button.

DoCmd.SetWarnings False

DoCmd.OpenQuery "querytoinsertgrade"

So if I put email code here I would want just what was just inserted
into the table to be emailed, how would this be done?