I need to write a macro within microsoft access which will run one of my predefined reports & then email it.

I have the report set up within access.

How can i write a macro to send the report and auto email.

I'm using access 2000 and i also can use access 2003.

thanks