By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

How to get Access to send an automated email when a change is made?

P: 1
Hi there,

I have created an MS Access database for use as a "helpdesk" system for the company that I work for.

Records are detailed as "requests" and the status of the requests are changed as the record moves down the progress chain from New Request to In Progress to Complete

I would like to know how to perform 2 actions within MS Outlook.

1. Get Outlook to automatically send an email when a request is created.

2. Get Outlook to automatically send an email when the status field is changed.

Any help you can give me would be greatly appreciated

Sep 2 '10 #1
Share this Question
Share on Google+
1 Reply

P: 579
Have you looked into using CDO? Other than using a third party app, like Redemption, CDO is the only way I know of to automate Outlook and send an email without getting the annoying Outlook security prompt. I think you will need an SMTP connection on your Exchange Server in order for CDO to work.

Here's a link to a CDO site that I've used before to write email scripts in VBScript (it should work for VBA too, but you may need to add references to the Outlook library and/or the CDO library):

You can use the technique found at the following site to help you track changes and use that as your basis for calling an email procedure (this should cover both of the requirements listed in your post):
Sep 3 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.