Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / October 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert - 05 Oct 2004 09:43 GMT
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] - 05 Oct 2004 12:26 GMT
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.

Signature

Sue Mosher, Outlook MVP
Author of
    Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

>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?"
[quoted text clipped - 5 lines]
> email and I have to wait 5 seconds to press "Yes". Sending 100 emails this
> way can be very ...
Alan - 05 Oct 2004 13:20 GMT
>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] - 05 Oct 2004 20:38 GMT
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.

Signature

Sue Mosher, Outlook MVP
Author of
    Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

>>Disabling the prompt is not an option unless you're the
>> Exchange administrator.
[quoted text clipped - 16 lines]
>
> Alan.
Angelize68 - 06 Oct 2004 14:27 GMT
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
[quoted text clipped - 7 lines]
>way can be very ...
>.
Sue Mosher [MVP-Outlook] - 06 Oct 2004 15:52 GMT
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.
Signature

Sue Mosher, Outlook MVP
Author of
    Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

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

>>-----Original Message-----
>>I want to supress whenever needed the message "A program
[quoted text clipped - 12 lines]
>>way can be very ...
>>.
Rob Shiras - 14 Oct 2004 21:44 GMT
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] - 29 Oct 2004 14:29 GMT
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.
Signature

Sue Mosher, Outlook MVP
Author of
    Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.