Outlook

[dale]

If I use the docmd.sendobject to send am email it is giving an alert
when outlook is the default mail program. Is there a way to supress this
in outlook or with code?

The message is "A program is trying to automatically send email on your
behalf. Do you want to allow this?"

Dale Brown

 

[jahoobob via AccessMonster.com]

I have searched and searched for a solution to this "problem" and have found
none. It is Outlook that is doing this. This, presumably, is to keep
someone from sending malicious code that would send info from your computer
out to whonever. I would guess, and it would be a guess, that either
changing Outlooks security settings ? or using another email as your default
would do it.

 

[Rod Plastow]

No, I believe it is Windows doing it and it is a security feature to stop
(inhibit) the spread of viruses via email clients. You cannot turn it off
otherwise that ability would defeat the purpose of having the feature in the
first place.

Anyone know any better?

Rod

 

[BruceM]

It sounds like it could be a third-party program such as a firewall or
anti-virus program. Is the message box identified in any way? I have used
SendObject with Outlook, and do not receive that message.
There are some security settings in Outlook that I suppose could cause a
message of that sort to be generated. Try changing Outlook message format
to plain text, then see if the problem still occurs.

 

[Rod Plastow]

Hi Bruce,

I think you will find it is a Microsoft component, whether it is an Outlook
component or a Windows component is somewhat immaterial. It is one of a set
of such components designed as I indicated to ensure that there is a 'live'
person in control and not a malicious program. There's a similar one that
reports that a program is trying to access your address book and do you want
to allow it to do so and for how long. You cannot disable these components
as that would neutralise the purpose of having them in the first place.

Does anyone know whether these messages are unique to Outlook or do they
also occur for Outlook Express and other mail clients?

So you do/did not get these pop up dialog boxes. What version of Access
are/were you using and what version of Windows? Do you keep Windows up to
date? When did you last use this without getting such a message? I'm
interested because I have an automated mailing program that invokes such a
message and although I referred to the dialog as pop up it is not; it is
often hidden below other clutter on the screen and sometimes I sit here
wondering why nothing is happening. Yes, I'd switch it off if I could.

Regards,

Rod

 

[jahoobob via AccessMonster.com]

As I said, I have searched and searched this and it is Outlook! I know this
may sound nitpicking but if you want to defeat an enemy you have to know from
whence it comes.
Apparently Outlook 2007 will disable this if you are running a current anti-
virus program according to this post at Outlookcode.com:
http://www.outlookcode.com/d/sec.htm
There may be some workarounds at:
http://www.outlookcode.com/d/secforms.htm
but I didn't have time to check it out.

No, I believe it is Windows doing it and it is a security feature to stop
(inhibit) the spread of viruses via email clients. You cannot turn it off
otherwise that ability would defeat the purpose of having the feature in the
first place.

Anyone know any better?

Rod

I have searched and searched for a solution to this "problem" and have found
none. It is Outlook that is doing this. This, presumably, is to keep

[quoted text clipped - 11 lines]

 

[BruceM]

I am using Access 2000 and Windows XP. I get updates automatically. All
updates are current. I last used this without getting the message about
five minutes ago, when I tested it to be sure of my facts.
The command button code for sending the e-mail is:
DoCmd.SendObject , , , strTo, strCC, , strSubj, strMsg
(strTo, etc. were defined earlier in the procedure)
I suggested a third-party program because I have seen similar messages from
such programs. Is the message box identified in any way?
Outlook security, in case it matters, is set to Restricted Sites, but there
are no sites on the list. I don't remember if I set it up that way.

Hi Bruce,

I think you will find it is a Microsoft component, whether it is an
Outlook
component or a Windows component is somewhat immaterial. It is one of a
set
of such components designed as I indicated to ensure that there is a
'live'
person in control and not a malicious program. There's a similar one that
reports that a program is trying to access your address book and do you
want
to allow it to do so and for how long. You cannot disable these
components
as that would neutralise the purpose of having them in the first place.

Does anyone know whether these messages are unique to Outlook or do they
also occur for Outlook Express and other mail clients?

So you do/did not get these pop up dialog boxes. What version of Access
are/were you using and what version of Windows? Do you keep Windows up to
date? When did you last use this without getting such a message? I'm
interested because I have an automated mailing program that invokes such a
message and although I referred to the dialog as pop up it is not; it is
often hidden below other clutter on the screen and sometimes I sit here
wondering why nothing is happening. Yes, I'd switch it off if I could.

Regards,

Rod

 

[Ron2006]

I believe most of this came in with Service Pack 2. So it will
sometimes depend on which components were updated.

However there is/are some alternatives:

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.

"You might be thinking of the free Express ClickYes
http://www.express-soft.com/mailmate/clickyes.html (although there are
others as well)"


2) The exchange admin can implement the security update (see
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263297)
But this affects all users that use a certain Outlook template, I
believe. And getting Admin to allow this is typically not easy.

3) 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 <[email protected]>"
..Update
End With


With iMsg
..Configuration = iCfg
..Subject = "Temp.xls"
..To = "(e-mail address removed)"
..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.

3) There is also an Outlook Email alternative that has other nice
aspects about it besides getting around the security item.

Here's one method, very good, but it's not free:

Total Access Emailer
http://www.fmsinc.com/products/Emailer/index.asp


Tom Wickerath
Microsoft Access MVP


http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html

=========================

Ron

 

[BruceM]

I run the standard updates. I am using SP3. All I know is that I don't
receive the message. I have Outlook installed in corporate/workgroup mode,
if that matters.
I use plain text messages, and don't use Word as my e-mail editor.

 

[Ron2006]

Interesting.....

There are a lot of people who wish they could get their Outlook to work
the way your's is. You are definitely in the minority. One explanation
is that the message CAN be set NOT to come up.

It could be that in the process of setting up your corporate/workgroup
mode this was what was done. (I think I would be quiet about it,
though, if you feel your other existing security measures are
sufficient.)

Here is the address of the write up at Microsoft for the original
security update release:

http://www.microsoft.com/presspass/features/2000/jun00/06-08outlook.mspx

At roughtly Paragraph 10 it says:

"Two other features should greatly diminish the spread of worm viruses
by warning users before they unknowingly spread a virus via email. If a
program tries to access your Outlook Address Book, you will be notified
by a dialog warning box and given the choice to let it access your
Outlook Address Book. "No" will be the default option. Owners of Pocket
PCs and other personal digital assistants such as Palm Pilots, or who
have other legitimate uses, will be able to select "Yes." The update
also warns you by a dialog warning box if a program is trying to send
email on your behalf. You will have the option to let the program send
email on your behalf, because there are legitimate business scenarios
where this is useful, but the default answer is "No" . This will help
curb the spread of certain viruses by putting users in control of their
desktop. With worm viruses, people usually don't know they are sending
an infected email to 500 of their closest friends. This update puts
customers in control of their address books and of programs that
attempt to send mail on their behalf. "


Ron

 

[Ron2006]

Later on in the same article he says:

Sinofsky: We have added administrative options to the update for
organizations that rely on server-based security settings, thus
enabling customization without sacrificing a high level of security.
Administrators will be able to choose which attachments cannot be
accessed or must be saved to a hard drive before opening. They will
also be able to choose when and if the warning dialog boxes appear.

 

[BruceM]

We do have Exchange Server here. Perhaps that is the key to this puzzle.
Now if I could only get them to allow me to e-mail mde files.

 

[Rod Plastow]

Hi Bob(?)

I concur, I also spent some time researching this today and all indications
point to it being an Outlook component, even down to the fact that Outlook
Help has an explanatory entry.

Why I originally thought it was Windows is because I used to get this same
message about 3 years ago when I used only Outlook Express as my mail client.
So is there an equivalent component in Outlook Express?

Best regards,

Rod

As I said, I have searched and searched this and it is Outlook! I know this
may sound nitpicking but if you want to defeat an enemy you have to know from
whence it comes.
Apparently Outlook 2007 will disable this if you are running a current anti-
virus program according to this post at Outlookcode.com:
http://www.outlookcode.com/d/sec.htm
There may be some workarounds at:
http://www.outlookcode.com/d/secforms.htm
but I didn't have time to check it out.

No, I believe it is Windows doing it and it is a security feature to stop
(inhibit) the spread of viruses via email clients. You cannot turn it off
otherwise that ability would defeat the purpose of having the feature in the
first place.

Anyone know any better?

Rod

I have searched and searched for a solution to this "problem" and have found
none. It is Outlook that is doing this. This, presumably, is to keep

[quoted text clipped - 11 lines]

Dale Brown

 

[Rod Plastow]

Hi Ron,

I seemed as though you were talking to yourself for a moment there!
Thanks for all the references. I shall try and make time to scan them.

It's intriguing why Bruce does not get this message; I've just constructed a
test mdb and up it pops. It's definitely Microsoft and almost assuredly an
Outlook component. Outlook Help (v2003 SP2) says the 'Yes' button is
disabled for 5 seconds so I guess all the automatic 'Yes Clickers' won't work
unless you can build a delay into them as well - probably the reason
Microsoft put the delay in.

Could Bruce's lack of message lay in an early comment in one of your
references that if you are using Microsoft Exchange then the administrators
have control over certain of these features?

Also I know I had this message 3+ years ago when Outlook Express was my mail
client and I was using Windows 98 and Access 2000 (or was it 97?). So it's
not just Outlook and it's not that recent although I own that Microsoft has
probably tightened it up a lot in successive releases and updates.

If we're honest we are all guessing, well informed guessing. It's time for a
Microsoft designer to step in and put the record straight. Do they read
these boards?

Regards,

Rod

 

[James]

Hi

I use Outlook Express and it has the same warning. However you can stop this
by going to Outlook Express, Tools Menu -> Options. Then click on the
Security TAB and 3rd or 4th option down there is a tick box that says "Warn
when applications try to send emails as me". Uncheck this and it will stop
the message coming up.

I am assuming there is something simmilar in Outlook.

James

Hi Bob(?)

I concur, I also spent some time researching this today and all indications
point to it being an Outlook component, even down to the fact that Outlook
Help has an explanatory entry.

Why I originally thought it was Windows is because I used to get this same
message about 3 years ago when I used only Outlook Express as my mail client.
So is there an equivalent component in Outlook Express?

Best regards,

Rod

As I said, I have searched and searched this and it is Outlook! I know this
may sound nitpicking but if you want to defeat an enemy you have to know from
whence it comes.
Apparently Outlook 2007 will disable this if you are running a current anti-
virus program according to this post at Outlookcode.com:
http://www.outlookcode.com/d/sec.htm
There may be some workarounds at:
http://www.outlookcode.com/d/secforms.htm
but I didn't have time to check it out.

No, I believe it is Windows doing it and it is a security feature to stop
(inhibit) the spread of viruses via email clients. You cannot turn it off
otherwise that ability would defeat the purpose of having the feature in the
first place.

Anyone know any better?

Rod

I have searched and searched for a solution to this "problem" and have found
none. It is Outlook that is doing this. This, presumably, is to keep
[quoted text clipped - 11 lines]

Dale Brown

 

[Rick Brandt]

Hi

I use Outlook Express and it has the same warning. However you can
stop this by going to Outlook Express, Tools Menu -> Options. Then
click on the Security TAB and 3rd or 4th option down there is a tick
box that says "Warn when applications try to send emails as me".
Uncheck this and it will stop the message coming up.

I am assuming there is something simmilar in Outlook.

There is not. In Outlook the warning cannot be turned off on the client PC.

 

[Ray]

Hi

There is a little program that you can run to get around this. It is called
ClickYes

http://www.contextmagic.com/

I have been using this with good results for a while now. I turn it on and
off as needed .

Microsoft have done t;his for good reason but the implemnetation leaves a
lot to be desired. I hope thaey do it better in the next version.

Hope this helps.

Ray