Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 915
  • Last Modified:

Disable Outlook Security Warning

I am working in access and I want to mail a table, but when press the button show me a message Microsoft Outlooik Allow Deny help dialog box. I do not want this box show up. How I can disable this message.
DoCmd.SendObject acSendTable, "RE_LastUpdated", acFormatXLS, "nospam@emaileditedbymbizup.com", _
, , "This is a Test", , False

Open in new window

0
Alfredo17
Asked:
Alfredo17
  • 2
  • 2
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you referring to the security warning? If so, you can use ClickYes to get around this:

http://www.contextmagic.com/express-clickyes/

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can also use other methods to send your email (like CDO), or use the Redemption library, which can bypass those warnings

http://www.dimastr.com/redemption/
0
 
jmoss111Commented:
Hi Alfredo,

You didn't mention the version of Office that you're working in, but I think in this instance it really doesn't matter. It appears that your email has been bitten by Microsoft Security. There are several ways to fix this but the simpkle quick and dirty way is to install http://www.contextmagic.com/express-clickyes/

There are several other methods, all better but also more difficult.

Regards,

Jim
0
 
jmoss111Commented:
Sorry, didn't mean to seem redundant. I left this window open on yesterday afternoon and just came back to it.
0
 
Alfredo17Author Commented:
I still do not get any right solution of how to use
I am using Access database Version 2003 and 2007
DoCmd.SendObject acSendTable, "RE_LastUpdated", acFormatXLS, "nospam@emaileditedbymbizup.com", _
, , "This is a Test", , False

This line work OK only problem is that I have to click OK to finish the process. I would like to know if some of you have an step by step solution. Many of you very kind try to solve but it is not so helpfull for me.
Could you please, give some right solution, I will appreciate.
Thank very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now