Send mass e-mail from within excel without outlook security messag

[Guest]

I want to supress whenever needed the message "A program is tryin to
automatically send e-mail on your behalf. Do you want to allow this?"

Outlook express has a check box in the "tools\options\security tab" but I
have not found anything in Microsoft outlook.

When I try to send emails from within excel I get this message for every
email and I have to wait 5 seconds to press "Yes". Sending 100 emails this
way can be very ...

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/sec.htm for your options with regard to the
"object model guard" security in Outlook 2000 SP2 and later versions.
Disabling the prompt is not an option unless you're the Exchange
administrator.

 

[Alan]

Disabling the prompt is not an option unless you're the
Exchange administrator.

Hi Sue,

I wasn't aware you could do that.

Is it possible to selectively disable for a single user?

I am thinking that would be useful when doing the newsletter run, and
then we could re-enable it after we are finished for security.

Do you know where the setting is? I looked under 'Exchange System
Manager' and also 'Active Directory Users & Computer', under the
individual user properties ('Exchange General' and 'Exchange
Features') but I could not find that setting.

Thanks in advance,

Alan.

 

[Sue Mosher [MVP-Outlook]]

Outlook security settings for Exchange users are managed with a special
public folder and form. See
http://www.slipstick.com/outlook/esecup/admin.htm You might consider using a
special account to send the newsletter and loosening security only for that
account.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Angelize68]

Search for freeware called "Express ClickYes" on the web.
It doesn't supress the question, but it clicks 'yes' on
your behalf whenever the dialog box comes up.

I use it myself and it works great.

Angelize68

-----Original Message-----
I want to supress whenever needed the message "A program is tryin to
automatically send e-mail on your behalf. Do you want to allow this?"

Outlook express has a check box in

the "tools\options\security tab" but I

 

[Sue Mosher [MVP-Outlook]]

Note that if you use Express ClickYes as-is, it leaves your system wide open
to malware that harvests addresses from or sends messages through Outlook.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Rob Shiras]

We are not using exchange. We use NetFolders in Outlook 2000 Internet
Mail Only. Is there a way we can disable the "sending an e-mail on your
behalf" functionality?

 

[Sue Mosher [MVP-Outlook]]

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. They
cannot be simply turned on or off with a user option or registry setting.

Standalone users 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 it's a VBA application you wrote yourself, you have these options for
modifying your program to avoid the security prompts (roughly in order of
preference):

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

-- 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.