Solved

Disable Outlook Security Warning

Posted on 2009-05-12
8
901 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

830 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