473,320 Members | 1,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Disable Item.Send Outlook Warning from Access?

My macro uses the Send Object (VBA Item.Send) function to email a
spreadsheet to an Outlook contact list. I want the function to be completely
automatic but Outlook displays a security warning message (...another
program is attempting to automatically email...) that requires user
intervention before the macro will finish execution. Can anyone advise me on
how to disable the Outlook warning? I tried the Warnings Off function but
realized it applies to the Access application, not to an external
application. Any help will be greatly appreciated!
May 31 '06 #1
9 28792
I think you would need to adjust the security settings in Outlook, not
normally a good thing.

My solution was to display the message and have the user click the Send
button in Outlook.

"JBuckner" <bu******@mail.unc.edu> wrote in message
news:44**********@news.unc.edu...
My macro uses the Send Object (VBA Item.Send) function to email a
spreadsheet to an Outlook contact list. I want the function to be completely automatic but Outlook displays a security warning message (...another
program is attempting to automatically email...) that requires user
intervention before the macro will finish execution. Can anyone advise me on how to disable the Outlook warning? I tried the Warnings Off function but
realized it applies to the Access application, not to an external
application. Any help will be greatly appreciated!

May 31 '06 #2
I know of no way around this prompt from within Access.

If you're using SQL Server for your data, you can use xp_sendmail to send it
from there, but then you don't get a copy in your Sent folder.
May 31 '06 #3
Try SMTP, you won't get it in sent mail but you can CC yourself. This
also gives the option of sending from a no-reply address if you want.
I need to use this to get around rule against placing outlook on Citrix
servers. You can even find scripts for sending SMTP mail through
webmail servers like Gmail or Yahoo.

HTH

Alex

JBuckner wrote:
My macro uses the Send Object (VBA Item.Send) function to email a
spreadsheet to an Outlook contact list. I want the function to be completely
automatic but Outlook displays a security warning message (...another
program is attempting to automatically email...) that requires user
intervention before the macro will finish execution. Can anyone advise me on
how to disable the Outlook warning? I tried the Warnings Off function but
realized it applies to the Access application, not to an external
application. Any help will be greatly appreciated!


May 31 '06 #4
Microsoft security updates made it impossible to do this
programmatically.

There is a software product out there that gets around it. I think it
is called something like "Click Yes" A google search should find it
for you. although I believe it still gives you the delay/processing
window until it can respond to the request.

May 31 '06 #5
microsoft DOES release a patch to disable this

or you can go back to an ancient version of outlook.. like 98 or maybe
even 97
I would love to bitch-slap the developer at Microsoft that let this bug
out in the wild.. it's like these assholes don't use their own dogfood;
they just dont give a shit anymore

and it's been 5 years

assholes in redmond should fix this immediately
Ron2006 wrote:
Microsoft security updates made it impossible to do this
programmatically.

There is a software product out there that gets around it. I think it
is called something like "Click Yes" A google search should find it
for you. although I believe it still gives you the delay/processing
window until it can respond to the request.


May 31 '06 #6
JBuckner wrote:
My macro uses the Send Object (VBA Item.Send) function to email a
spreadsheet to an Outlook contact list. I want the function to be completely
automatic but Outlook displays a security warning message (...another
program is attempting to automatically email...) that requires user
intervention before the macro will finish execution.


You may wish to use CDO. Here is a sample.

Public Sub VerySimpleSendMailWithCDOSample()

Dim iCfg As Object
Dim iMsg As Object

Set iCfg = CreateObject("CDO.Configuration")
Set iMsg = CreateObject("CDO.Message")

With iCfg.Fields
..Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
..Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport")
= 25
..Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") =
"smtp.aim.com"
..Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate")
= 1
..Item("http://schemas.microsoft.com/cdo/configuration/sendusername") =
"MyUserName"
..Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") =
"MyPassord"
..Item("http://schemas.microsoft.com/cdo/configuration/sendemailaddress")
= "Lyle Fairfield <ly***********@aim.com>"
..Update
End With

With iMsg
..Configuration = iCfg
..Subject = "Temp.xls"
..To = "lf********@cogeco.ca"
..TextBody = "This is the latest!"
..AddAttachment "C:\Program Files\Backup Scripts\Temp.xls"
..Send
End With

Set iMsg = Nothing
Set iCfg = Nothing

End Sub

I believe that you can link to your Outlook Contacts (File - Get
External Data - Link Tables) to get your addresses.

May 31 '06 #7
On Wed, 31 May 2006 13:22:56 -0400, "JBuckner" <bu******@mail.unc.edu>
wrote:

That would defeat the purpose of the warning, wouldn't it? The warning
is there so users are alerted to unusual behavior (e.g. a virus
surrepticiously sending mail on your behalf). If you could turn it off
programmatically, so could a virus writer.

You'll have to use a different method (Lyle has a good suggestion,
"Outlook Redemption" is another), or turn these warnings off globally
(which you can if you have an Exchange back-end; not sure if you're
using PST).

-Tom.

My macro uses the Send Object (VBA Item.Send) function to email a
spreadsheet to an Outlook contact list. I want the function to be completely
automatic but Outlook displays a security warning message (...another
program is attempting to automatically email...) that requires user
intervention before the macro will finish execution. Can anyone advise me on
how to disable the Outlook warning? I tried the Warnings Off function but
realized it applies to the Access application, not to an external
application. Any help will be greatly appreciated!


May 31 '06 #8
Tom van Stiphout wrote:
On Wed, 31 May 2006 13:22:56 -0400, "JBuckner" <bu******@mail.unc.edu>
wrote:

That would defeat the purpose of the warning, wouldn't it? The warning
is there so users are alerted to unusual behavior (e.g. a virus
surrepticiously sending mail on your behalf). If you could turn it off
programmatically, so could a virus writer.

You'll have to use a different method (Lyle has a good suggestion,
"Outlook Redemption" is another), or turn these warnings off globally
(which you can if you have an Exchange back-end; not sure if you're
using PST).

-Tom.
My macro uses the Send Object (VBA Item.Send) function to email a
spreadsheet to an Outlook contact list. I want the function to be completely
automatic but Outlook displays a security warning message (...another
program is attempting to automatically email...) that requires user
intervention before the macro will finish execution. Can anyone advise me on
how to disable the Outlook warning? I tried the Warnings Off function but
realized it applies to the Access application, not to an external
application. Any help will be greatly appreciated!


Or use a free little utility called Express Click Yes.

Bob
Jun 1 '06 #9
There are two ways to get round this neither of them can be implemented in
Access.

1) There is a product call "Click Yes" which runs in the users system tray
and automatically clicks Yes on the dialog
2) The exchange admin can implement the security update (see
http://support.microsoft.com/default...;en-us;Q263297)
--

Terry Kreft
"JBuckner" <bu******@mail.unc.edu> wrote in message
news:44**********@news.unc.edu...
My macro uses the Send Object (VBA Item.Send) function to email a
spreadsheet to an Outlook contact list. I want the function to be completely automatic but Outlook displays a security warning message (...another
program is attempting to automatically email...) that requires user
intervention before the macro will finish execution. Can anyone advise me on how to disable the Outlook warning? I tried the Warnings Off function but
realized it applies to the Access application, not to an external
application. Any help will be greatly appreciated!

Jun 1 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Google Mike | last post by:
I've got RH9 Linux with default PHP. Is there a way to send email on Linux to an Exchange Server from PHP and/or other tools when there is *NOT* SMTP access? Has anyone figured out a way to...
0
by: Akira | last post by:
Could someone tell me how to send outlook appointment email from asp page? I would like appointment email just like one outlook can send out. I tried to look for an answer for this, but it seems...
6
by: Bob Alston | last post by:
I am using the Outlook library to send emails from Access. I have Outlook open and run a program to respond yes to the security question (Express click Yes). It seems to take about 5 seconds...
1
by: Dean Slindee | last post by:
I have a VB.NET application where I am writing emails from rows in a table. For each email, an dialog box with an Outlook warning message appears. I would like to be able to write the emails...
1
by: Mr T | last post by:
I know how to send email from Access and I know how to create a custom form in Outlook. but.... How do I put the email info from Access into the Outlook custom form ??? Dim MyDB As Database Dim...
0
by: topspin | last post by:
I'm trying to pool contact list and code works fine but its open an outlook warning massege, please help me. var i,j : integer; OutlookApplication1 : OleVariant; NameSpace : OleVariant; ...
1
by: =?Utf-8?B?VGVkZXNjbw==?= | last post by:
I am running Outlook Express 6 on my home computer. I am able to access my work email from home it is Outlook Web Access. I understand that the two are different. I can not insert pictures with...
1
by: kumana1 | last post by:
This site is fantastic, first of all. Second of all, thank you for your time in this matter. I have been using some code that was posted on here (I apologize for not being able to remember who)...
4
by: macca | last post by:
hi, Does anybody know if it's possible to log into Outlook Web Access using PHP? I mean, if I have the username, password and email address I need to have a link that opens directly into...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.