Created excel files and need to AUTO SEND them using OUTLOOK

[Guest_imported]

Hello
I have two daily reports that I create using Access, it dumps them out to an excel format.
Now, I need to have OUTLOOK autosend these files after they are created.
I have tried using some other codes and none seem to work correctly.
My default mail program is Outlook express, so I never open OUTLOOK at all, to my best understanding, there has to be code that can send the email without having to open OUTLOOK.

Any ideas>
thanks - Aaron

 

[danvlas]

Why don't you use
DoCmd.SendObject acReport,"ReportName", acFormatXLS,"To@email.com","CC@email.com","BCC@email.com","Subject here","Body message here", False

HTH

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[ttmac]

Aaron,

Have a look at OLE automation example on

http://www.erlandsendata.no/english/downloads/programming.htm

Tom.