By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 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

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


beacon
100+
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): 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
Sep 3 '10 #2

Post your reply

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