E-Mail query using transfer spreadsheet

R

Randy

Access 2000. I have a form where I enter a new file name, a beginning date
and an ending date. I click on a cmd button which runs a macro, which
creates an excel file I just created and saves it to C:\District. I then am
able to attach the newly created excel file to my E-mail program for
e-mailing. Is there a way to send the file directly to my e-mail program as
an attachment? This way I dont have to go through the steps of opening
C:\Disteict and attaching the file.
 
Top