Send report electronically

A

Amy

I have created a report in access and was wondering if
there was any way to send the report out electronically
either in Microsft Word, Excel or as an attachment in an e-
mail after it is generated?

I would like to send the report to someone that doesn't
have access to the database.
 
J

Jim/Chris

Create a macro and use the SendObject action. I would
suggest the Snapshot format. This is available free from
Microsoft.

Jim
 
A

Amy

Thanks Jim. I created the macro now how do I incorporate
this into my report. So when the user clicks on the report
button they get a preview of the report but I would like
this macro to run as well.
 
Top