emails from access

  • Thread starter Thread starter mon
  • Start date Start date
M

mon

Hi Happy Helpers
Am I aable to set up something in Access so that an email
can be sent on a certain date (as a reminder)
Thanks
Mon
 
Certainly, but you will need the program to be open so that the code will
run.

There are 2 ways to do this.:

1. Use a scheduling program to open Access and have Access run a check for
the date and send the email if applicable.

2. Leave the Access app open, and poll it with the Timer event of a form.

You may have a problem with the Outlook current security settings which will
not allow email to be sent automatically. In that case, you may need another
email program. From Access, use SendObject with any default mail client, or
you can use the code on my website to send mail in Outlook.

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top