Send report electronically

  • Thread starter Thread starter Amy
  • Start date Start date
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.
 
Create a macro and use the SendObject action. I would
suggest the Snapshot format. This is available free from
Microsoft.

Jim
 
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.
 
Back
Top