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

When sending email items how does on prevent allow/deny message box

P: 1
Expand|Select|Wrap|Line Numbers
  1. DoCmd.SendObject acSendNoObject, , , _
  2.     EmailAddress, , , _
  3.     "Katikti Bridge Club - Subs" & " " & Now(), _
  4.     "Please pay " & myr!Sub & " to the club Westpac Account  03 1550 0025952 00", _
  5.     False
a Microsoft outlook box appears but I can't see in ACCESS how to prevent this message occurring so that my email messages can be sent automatically.

Attached Images
File Type: jpg Outlook Box.JPG (26.9 KB, 324 views)
Jan 15 '19 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,284

Welcome to Bytes!

This is not an error but a security protocol set and managed by your friendly local network administrators. There is no means, whatsoever that I know of, to prevent this security banner from popping up when these settings are set at the Network level, as your administrators are preventing potential malicious code from being malicious. It also prevents productive code from being productive.

I just set the display flag to “True”, display the message and then click send.

Also, it is highly advisable that you establish variables for such transactions, and then simply use the variables in your SendObjecct statement. This allows for better troubleshooting and cleaner code. Additionally, you should also get into the habit of using named arguments in your functions, so you can avoid the multiple sets of commas, which can get confusing.

Hope this hepps!
Jan 15 '19 #2

Post your reply

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