email Access report

[bmoberly8888]

I want to know if there is a way to distribute Access reports to individuals using their email address (or some other criteria). The whole report would have many timekeepers - but I want each timekeeper's report to go to him/her and not send all of the data. Also, if these reports could be scheduled to run at certain times, i.e. once a week, etc.

 

[PHV]

Have a look at the 4th argument of the DoCmd.OpenReport method and at the DoCmd.SendObject method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bmoberly8888]

Sorry,I don't understand what you mean. I know there's a lot of Access that I don't know about - I use Access a lot and create a lot of reports - but this is obviously something beyond what I've worked with and will need more information about how to do. Thanks.