Re: Scheduling notification emails
From: Graham Mandeno (Graham.Mandeno_at_nomail.please)
Date: 03/25/04
- Next message: Toffee: "Re: Form entering data in wrong record"
- Previous message: Ripper: "Re: Open a Form in Add Mode"
- In reply to: JD Kronicz: "Scheduling notification emails"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Mar 2004 10:30:54 +1200
Hi JD
First, don't be discouraged - you've come to the right place :-)
For the scheduler, the best solution depends on a few things like how timely
the emails need to be. Do they need to be sent within minutes of the event
coming due, or would once a day (or even less frequently) be OK? You say
your laptop is sometimes disconnected from the network, but does the
database back-end live on the laptop? If so then you will only be able to
send the email when you are online.
You can use Access for the mailer, but I suggest you create a small
dedicated front-end database linked to the required tables in your back-end.
If your back-end is on the network, then I suggest you run this mailer
front-end on a permanently connected PC, not on your laptop. This front-end
can either be open all the time, and use a form timer to perform the
periodic polling of the data, or it can be launched by the task scheduler
and poll the data on opening, then close itself when done.
The polling operation would simply run a query to see if there were any
messages to send, generate and send the messages, update the data
accordingly, and terminate.
If you want to send the email through Outlook, take a look at Dmitry
Streblechenko's Outlook Redemption at http://www.dimastr.com/redemption/.
It's a great product which circumvents the "security features" of Outlook
without compromising its *security*. There are also a number of SMTP
controls available.
-- Good Luck! Graham Mandeno [Access MVP] Auckland, New Zealand "JD Kronicz" <anonymous@discussions.microsoft.com> wrote in message news:BB2A1923-4404-499D-9964-9884AA971637@microsoft.com... > Hi > I have spent a number of hours reviewing the information on this subject and I am becoming a bit discouraged. I am developing an equipment manager applicaion in Access. I would like the program to be able to generate emails automatically for various purposes (eg. to notify a responsible individual that a piece of equipment is due for preventative maintenance). I am trying to work out two issues: > 1. Scheduling the code that will send the emails - I know that windows has a built in scheduling utilitiy and also that there are others that are available. What I am not clear about is where the scheduler should be set up. I have a laptop computer that is not always connected to the network. Is this type of thing generally done on a server or is it generally done on some other dedicated (i.e. non user) computer? > 2. Sending the emails - If I try and send the emails through outlook the security features in outlook will prevent this from occuring in an unattended fashion. This seems like a commonly required type of functionality. What is the best way around the security features in Outlook? (use a different email program that supports automation?) How does Microsoft expect a developer to design functionality for automated email notificaitons with the security features that have been implimented in Outlook? > > Any help on this issue would be greatly appreciated.
- Next message: Toffee: "Re: Form entering data in wrong record"
- Previous message: Ripper: "Re: Open a Form in Add Mode"
- In reply to: JD Kronicz: "Scheduling notification emails"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
