EmailingSpecificReports.mdb (expert)

Please consider donating $1 per sample downloaded, find out why here
Access 97 (37 KB)

This illustrates how to email the same report with different data to a variety of users. The User table holds the user's email name, and the criteria on which the report is based. In this case it is just one criteria [Acct] = whatever is in the Param field. The module goes through the Users table one record at a time and re-creates the query on which the report is based. Then emails the report to the appropriate user as indicated in the User table. If there is no data in the report, it aborts the email. (See the report's OnNoData event.)

To use this function, you must have email installed and have the names of real email users in the Users table. Then just go to the module, insert your cursor anywhere in the subroutine and push the Go/Continue button.

This same is meant to only be used with Access 97 and Outlook 98 or earlier. The SendObject method no longer works reliably with any version of Office 2000 SR1 and higher. It really isn't a problem with Access, but with Outlook. See this link for more information:;en-us;q260819




Need Winzip?

Return to Main Page