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

[Adam Docrat]

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

Adam

[beacon]

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): http://www.paulsadowski.com/wsh/cdo.htm

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): http://articles.techrepublic.com.com...1-6166807.html