Disable Item.Send Outlook Warning from Access?

JBuckner

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

paii, Ron

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" <bucknerj@mail.unc.edu> wrote in message
news:447dd0ef$1_3@news.unc.edu...[color=blue]
> 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[/color]
completely[color=blue]
> 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[/color]
on[color=blue]
> 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!
>
>[/color]

May 31 '06 #2

Rick Wannall

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

alex

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:[color=blue]
> 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![/color]

May 31 '06 #4

Ron2006

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

dbahooker@hotmail.com

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:[color=blue]
> 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.[/color]

May 31 '06 #6

Lyle Fairfield

JBuckner wrote:[color=blue]
> 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.[/color]

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 <lylefairfield@aim.com>"
..Update
End With

With iMsg
..Configuration = iCfg
..Subject = "Temp.xls"
..To = "lfairfield@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

Tom van Stiphout

On Wed, 31 May 2006 13:22:56 -0400, "JBuckner" <bucknerj@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.

[color=blue]
>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!
>[/color]

May 31 '06 #8

Bob Alston

Tom van Stiphout wrote:[color=blue]
> On Wed, 31 May 2006 13:22:56 -0400, "JBuckner" <bucknerj@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.
>
>
>[color=green]
>>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!
>>[/color]
>
>[/color]
Or use a free little utility called Express Click Yes.

Bob

Jun 1 '06 #9

Terry Kreft

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" <bucknerj@mail.unc.edu> wrote in message
news:447dd0ef$1_3@news.unc.edu...[color=blue]
> 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[/color]
completely[color=blue]
> 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[/color]
on[color=blue]
> 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!
>
>[/color]

Jun 1 '06 #10