Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - EmailingSpecificReports.mdb (advanced)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

EmailingSpecificReports.mdb (advanced)

 Post Reply Post Reply
Author
Message
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Status: Offline
Points: 249
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: EmailingSpecificReports.mdb (advanced)
    Posted: 01 Aug 2008 at 4:50am

Please consider donating $1 per sample downloaded, find out why here.
 

EmailingSpecificReports.mdb

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:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q260819
 
Download
Access 97 (37 KB):
EmailingSpecificReports.zip

Consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down