Automatic E-Mail

[Tony F]

I have built a database using Access 2000 to manage concessions I wish to
automatically inform, via e-mail, the concession originator that their
concession is about to expire. The concessions are uniquely numbered,
autonumber, the originator's name and e-mail address is on a separate table
and the concession table includes the expiry date. As I would prefer to
inform originators only of their own concession's imminent expiry it's likely
that more than 1 e-mail may need to be sent on any given date.

Is this possible?

Thanks in anticipation

Tony F

 

[Kipp Woodard]

You can definitely do this with Access, though it may be a bit clunky.

Here's what you would have to do...

- Your database would have to be open during the time span that you would be
sending out the notifications.
- You would have to have a form open as well.
- You would use the form's OnTimer and TimerInterval properties to check on
a sensible interval for whether to send a message.
- If you want unattended sending of e-mail, that is more challenging, as
using the SendObject action causes a prompt for whether you want to send the
message. There are many approaches as to how to deal with that.

Here is a site that covers Access/EMail pretty extensively.

http://www.granite.ab.ca/access/email.htm

 

[Tony F]

Thanks for speedy response Kipp, unattended is preferable so I'll have a look
at the detailed website to, hopefully, find my solution.

Tony F

 

[Peter Hibbs]

Tony,

You could also use the code at :-

http://www.ostrosoft.com/OSSMTP6.asp

to send an email without using MS Outlook or Outlook Express (or
whatever). This option requires a DLL file to be installed and
registered on your PC. If you need any code to send the email I can
post it here for you, just let me know if you need it.

HTH

Peter Hibbs.

 

[Tony Toews [MVP]]

Thanks for speedy response Kipp, unattended is preferable so I'll have a look
at the detailed website to, hopefully, find my solution.

Unattended is a bit tricky and downright undependable. I'd ensure the
user opened the application once a day just to check if any emails
needed sending.

Tony