automate from access sending an excel workbook via email

[Guest]

I have a code that opens an exel workbook from an access form command button
where the user may enter data. After my user enters the data, I would like
to program from Access a way to send the Excel workbook via email to a
defined group? (I understand that a macro can be created that sends an
"Access" object - not an Excel object.)

Thanks.

 

[Guest]

Hi,
the method sendobject can only send internal database objects and only one
at a time. You will need to find an alternative which can attach an external
file (xls in your case) to an email. There are many possibilities including
automating outlook from access or redemptions. Search the news group and I'm
sure you will find alot of sample code.
HTH
Good luck

 

[Guest]

Thanks!

Hi,
the method sendobject can only send internal database objects and only one
at a time. You will need to find an alternative which can attach an external
file (xls in your case) to an email. There are many possibilities including
automating outlook from access or redemptions. Search the news group and I'm
sure you will find alot of sample code.
HTH
Good luck