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

Access form sends confirmation email on completion

P: 6

I have an Access form that users use when logging a fault with system.

The user adds the record by clicking a submit button and a table is populated with the following:

[FaultID] - unique id of fault
[FaultDescription] - description of fault
[Username] - name of person who logged fault also contact in address book
[priority] - priority of fault

What I'd like to be able to do is when a record is added it automatically sends the user an email saying something like the following:


To: [username]
Subject: Fault no [FaultID]

[Username] ,

Your fault has now been logged with ID of [faultID] and as [priority] case.

We will deal with the fault as soon as we can.


Database Team


Any ideas would be greatly appreciated.


Simon Tindall
Jan 14 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 374
That would be easy except for one thing, the Outlook security patch that prevent thirdparty applications from sending email on someones behalf without them getting a lot of dialog boxes telling them that something on there computer is sending an unwanted email on there behalf, do they want to do this, or not. And most people that don't know about this warning will tell the system NOT to send the email.

So my thought to this, since I've developed a system that works on a simular basis, is to receive the logged message, then you produce the response so that you know that the system is going to send this message to them on your behalf and you would know how to respond to the messages that come up on windows.

If you need detail code, let me know. Have a few examples.

Joe P.
Jan 15 '08 #2

Post your reply

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