Solved

Disable Outlook Security Warning

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

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…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

823 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