Email Reminders

[kenkabozu]

I would like to automatically generate email reminders for say passport
renewals one month prior to their expiry date. How do I do it?

 

[Wayne-I-M]

Best bet would be to create a query giving the date one month before the
passport end date then run an autoexec to check warn of passports that need
re-newing on open. Or run the macro each day at a certain time.

Something like
iif warning date = Date() then send mail

Create a standard report to warn people of the need to re-new the passport
and use sendobject to send them warnings.

You will need to have a table with the e mail address and the passport end
dates for this to work.

 

[a a r o n . k e m p f]

SQL Server can send emails via XP_SENDMAIL

trying to do the same thing, on the client-- that is not reccomended
because it is a security risk

 

[Wayne-I-M]

What security risk.

Sorry but I'm not an access "expert", I just make databases the best I can.
I can't see how sending an e mail to someone is a security risk.

I sent about a zillion people e mails over the last few years direct from
access - so please explain secutrity risk - really would like to know if I'm
doing something wrong.

 

[aaron.kempf is a robot]

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.

 

[Tony Toews [MVP]]

Best bet would be to create a query giving the date one month before the
passport end date then run an autoexec to check warn of passports that need
re-newing on open. Or run the macro each day at a certain time.

Something like
iif warning date = Date() then send mail

What about weekends and holidays? I would suggest using <= and
flagging those records whose reminders you just sent out so you don't
resend them.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Wayne-I-M]

What about weekends and holidays?
E Mails can be sent at weekends - so does scheduler ?

I would suggest using <= and flagging those
records whose reminders you just sent out so you
don't resend them.

Better still - use an update query to flag the records that have had e mails
sent to them. You would need to add a date/time field to some table to hold
this flag or just a yes/no field if you don't need to record when the mail
was sent

Mind you - I am assuming you have zillions of e mails to send - this would
make it worth doing. If there are only a few then use Tonys idea of just
flagging OnClick or something else.



--
Wayne
Manchester, England.

 

[Tony Toews [MVP]]

E Mails can be sent at weekends - so does scheduler ?


Better still - use an update query to flag the records that have had e mails
sent to them. You would need to add a date/time field to some table to hold
this flag or just a yes/no field if you don't need to record when the mail
was sent

Yes, that's what I meant when I said flagging those records. Although
I should've been more explicit.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/