I have a form that people fill in to make a measurement request. When they click a button to save and send the form it sends them an email confirming their job number.

When they click this button Ms Access gives a message box saying "this program is trying to send email - do you want to allow this?" I would like to stop this message being shown as the email always needs to be sent.

Is there a way to do this?

Julie,

This is a security implementation by Microsoft to ensure no malicious e-mails are sent from your machine (eg. viruses etc).

This is a message generated by each user's machine, and is there to protect users from malicious Access scripts, even though yours is not. Unfortunately there is not a 'Yes, and don't ask me again' option.

"When you apply the Microsoft Outlook E-mail Security Update, the Outlook E-mail Security Update provides additional levels of protection against malicious e-mail messages. The Outlook E-mail Security Update changes the way that attachments are handled by Outlook and the way that Outlook can be controlled programmatically." http://support.microsoft.com/kb/263084

You may be able to adjust settings if your organisation uses Microsoft Exchange: http://support.microsoft.com/kb/290499/

There is also a 3rd party application called 'clickyes', but I believe would need to be installed on every user's machine, which probably isn't ideal: http://www.contextmagic.com/express-clickyes/

Regards, Rich