Print Page | Close Window

EmailingSpecificReports.mdb (advanced)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=352
Printed Date: 19 Dec 2018 at 3:24am


Topic: EmailingSpecificReports.mdb (advanced)
Posted By: Roger Carlson
Subject: EmailingSpecificReports.mdb (advanced)
Date Posted: 01 Aug 2008 at 4:50am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - 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 - http://support.microsoft.com/default.aspx?scid=KB;en-us;q260819
 
Download
Access 97 (37 KB):
uploads/5/EmailingSpecificReports97.zip - EmailingSpecificReports.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window