Notifications Microsoft Access and Outlook

5 pts.
Tags:
Microsoft Access
Outlook
I have created a form and one of the fields in the form is for the date of expiry for certifications. Is there a way that access can send a notification or some type of flagging through Outlook (or any other method for that matter) to let me know that someones certification expiry date is coming up?
ASKED: June 12, 2008  5:04 PM
UPDATED: June 13, 2008  2:31 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can write a query block into the Access database to handle the sending of the emails. You would need to write some software to open the Access database and run the query.

VBA should include the ability to send email.

—————————————–
There is a way to include SMTP functionality within Access itself to send emails. Write a VBA module to do this. Build a macro called autoexec that invokes the VBA module, then exits Access. You can then create a Windows Scheduler job to open the database at a specific time. The database will open, send the email, then exit. When you need to get into the database, hold down the [Shift] key to skip the autoexec macro execution. Or create a mail-only database with links to the tables and use that one for the nightly mail job.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jerry Lees
    What type of form is it? A contact form, message, appointment, etc? You likely could do this with a VBA Macro, but I'll need more information to be able to point you in the right direction.
    5,335 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following