Solved

Disable Outlook Security Warning

Posted on 2009-05-12
8
897 Views
Last Modified: 2012-06-21
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
Comment
Question by:Alfredo17
  • 2
  • 2
8 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 24368867
Are you referring to the security warning? If so, you can use ClickYes to get around this:

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

0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 24370644
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
 
LVL 18

Expert Comment

by:jmoss111
ID: 24374014
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
 
LVL 18

Expert Comment

by:jmoss111
ID: 24374029
Sorry, didn't mean to seem redundant. I left this window open on yesterday afternoon and just came back to it.
0
 

Author Comment

by:Alfredo17
ID: 24858546
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

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now