[AccessD] Auto e-mail

I don't even know what sp_AOCreate is.  But I have done what you're talking
about in VBA.  I just linked the SS table to Access and cycle through the
recordset looking for tardy users and use Sendobject when I find one.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Rojas
Sent: Monday, October 27, 2003 2:15 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Auto e-mail


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.

Thanks!
JR




This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com