[AccessD] Auto e-mail

On 27 Oct 2003 at 15:15, Joe Rojas wrote:

> Hi All,
> 
> I have a time sheet application using SS7.0 as the BE.
> I am trying to come up with a solution that will automatically send out, via
> e-mail, reminders to all users who have not filled out their time sheets.
> 
> At first I thought I might create a stored procedure that used sp_OACreate
> to create an ADODB.Recordset and then iterate through the recordset of tardy
> users and, for each one, use xp_sendmail to alert them. This method seems
> little cumbersome with all the syntax needed to use sp_OACreate effectively.
> 
> Then I thought I might create a VB Service that would do the same thing at
> the desired interval, but this seemed a little much for what I was hoping
> would be a simply task.
> 
> Are my only options the ones I listed above or does anyone have a better
> approach.
> 
>

How about an Access solution (after all this is the Access list<g>)

Either link to a view ro create use a passthrough query to pull the 
recordset from the SP.

Set an Autoexec macro to RunCode and call a function which opens the 
RS and steps through it using DoCmd.SendObject (if you are going to 
have an email client available and open on the executing machine, or 
use Blat or some other similar app/dll)  followed by a Quit

Then schedule Access to open the mdb ervery night/morning
or run the code the first time the application is opened each day

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.