sending e-mail's

[David]

The basic layout of the macro is this:

OpenQuery
OpenQuery
SendObject
SendObject
MsgBox

The two OpenQuery's make sure that any and all open
forums have been saved so that no information loss will
occur.

The first SendObject sends a few tables, in RTF format,
to two addresses and the second SendObject sends the same
tables, in Excel format, to a handheld.

The MsgBox exists soly to show that the macro executed
correctly.

Before our office-wide software update, once you clicked
the command button associated with this macro, everything
would execute perfectly. Now we are running both Windows
and Office XP and everything still executes fine, but two
new message boxes pop-up.

The first reads "Choose Profile" and has a drop down list
with only one option in it: Outlook. There are 5 cmd
buttons in the msgbox - the only one that stands out here
is options >> which allows you to set the current item as
default. Even if you check default and click ok, this
msgbox will pop-up the on the next SendObject/the next
time you execute the macro.

The second MsgBox reads "A program is trying to
automatically send e-mail on your behalf. Do you want to
allow this? [...] If this is unexpected, it may be a
virus and you should choose 'No'". The three command
buttons are Yes, No, and Help.

If you want to click yes, you will have to wait for 5
seconds before you can click it (the cmd button is
disabled until then).

I'm assuming that the second MsgBox is for virus
protection (duh) and that it's generated by Outlook, not
Access (duh again).

The first message box is simply annoying, especially
considering that Outlook is the only option on the list.
What makes it even more annoying is that when I
check 'default' it still asks the question every time.
The second message box is more annoying in that I have to
wait five seconds before I can click ok.

Any ideas as to how I can get one/both of the messages to
go away forever? This macro is run daily and it get
annoying.

 

[Cheryl Fischer]

Questions regarding the Outlook Security prompt are asked very frequently.
The most complete answer has been provided by Outlook MVP Sue Mosher and is
as follows:

BEGIN QUOTED MATERIAL:

"The security dialogs that pop up when an application tries to access
certain Outlook properties and methods are designed to inhibit the spread of
viruses via Outlook; see
http://www.slipstick.com/outlook/esecup.htm#autosec. If you are a standalone
user, Outlook provides no way to suppress this behavior. However, you can
use a free tool called Express ClickYes
(http://www.express-soft.com/mailmate/clickyes.html) to click the security
dialog buttons automatically. Beware that this means if a virus tries to
send mail using Outlook or gain access to your address book, it will
succeed.

"If you're the administrator in an Exchange Server environment, you can
reduce the impact of the security prompts with administrative tools. See
http://www.slipstick.com/outlook/esecup/admin.htm

"If it's an application you wrote yourself, you can use one of these
approaches to redo the program:

-- Use Extended MAPI (see http://www.slipstick.com/dev/mapi.htm) and C++
or Delphi; this is the most secure method and the only one that Microsoft
recommendeds.

-- Use Redemption (http://www.dimastr.com/redemption/), a third-party
COM library that wraps around Extended MAPI but parallels the Outlook Object
Model

-- Use SendKeys to "click" the buttons on the security dialogs that your
application may trigger. See
http://www.slipstick.com/outlook/esecup.htm#autosec for a link to sample
code.

-- Program the free Express ClickYes
(http://www.express-soft.com/mailmate/clickyes.html) tool to start suspended
and turn it on only when your program needs to have the buttons clicked
automatically."

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

END OF QUOTED MATERIAL




--
Cheryl Fischer
Law/Sys Associates
Houston, TX

The basic layout of the macro is this:

OpenQuery
OpenQuery
SendObject
SendObject
MsgBox

The two OpenQuery's make sure that any and all open
forums have been saved so that no information loss will
occur.

The first SendObject sends a few tables, in RTF format,
to two addresses and the second SendObject sends the same
tables, in Excel format, to a handheld.

The MsgBox exists soly to show that the macro executed
correctly.

Before our office-wide software update, once you clicked
the command button associated with this macro, everything
would execute perfectly. Now we are running both Windows
and Office XP and everything still executes fine, but two
new message boxes pop-up.

The first reads "Choose Profile" and has a drop down list
with only one option in it: Outlook. There are 5 cmd
buttons in the msgbox - the only one that stands out here
is options >> which allows you to set the current item as
default. Even if you check default and click ok, this
msgbox will pop-up the on the next SendObject/the next
time you execute the macro.

The second MsgBox reads "A program is trying to
automatically send e-mail on your behalf. Do you want to
allow this? [...] If this is unexpected, it may be a
virus and you should choose 'No'". The three command
buttons are Yes, No, and Help.

If you want to click yes, you will have to wait for 5
seconds before you can click it (the cmd button is
disabled until then).

I'm assuming that the second MsgBox is for virus
protection (duh) and that it's generated by Outlook, not
Access (duh again).

The first message box is simply annoying, especially
considering that Outlook is the only option on the list.
What makes it even more annoying is that when I
check 'default' it still asks the question every time.
The second message box is more annoying in that I have to
wait five seconds before I can click ok.

Any ideas as to how I can get one/both of the messages to
go away forever? This macro is run daily and it get
annoying.