PC Review


Reply
Thread Tools Rate Thread

Automating Outlook in VB

 
 
Ivan Debono
Guest
Posts: n/a
 
      29th Feb 2004
Hi,

I have wrote a little program in VB to send emails to contacts using
outlook. But everytime I send an email, a window pops up and I have to wait
5 seconds, click Yes and then the email is sent.

Is there a way to overcome this??

Thanks,
Ivan


 
Reply With Quote
 
 
 
 
Sue Mosher [MVP-Outlook]
Guest
Posts: n/a
 
      29th Feb 2004
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.

However, Outlook 2003 does not show security prompts on three specific types
of applications:

-- VBScript code in published, non-oneoff Outlook forms

-- Outlook VBA code that uses the intrinsic Application object

-- Outlook COM add-ins properly constructed to derive all objects from
the Application object passed by the OnConnection event

In earlier versions of Outlook, 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 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 and either your application needs
to support versions besides Outlook 2003 or your application runs extenal to
Outlook, you have these options for modifying your program to avoid the
security prompts (roughly in order of preference):

-- 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
recommends. However, it applies only to COM add-ins and external programs;
you cannot use Extended MAPI in Outlook forms or VBA.

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

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


"Ivan Debono" <(E-Mail Removed)> wrote in message
news:OKWRIao$(E-Mail Removed)...
> Hi,
>
> I have wrote a little program in VB to send emails to contacts using
> outlook. But everytime I send an email, a window pops up and I have to

wait
> 5 seconds, click Yes and then the email is sent.
>
> Is there a way to overcome this??
>
> Thanks,
> Ivan
>
>



 
Reply With Quote
 
Ivan Debono
Guest
Posts: n/a
 
      1st Mar 2004
I've got Outlook 2003. I've moved the code inside a macro, created a form,
etc...

Is there a way to access the form from an outlook button or something like
that??

Thanks,
Ivan

"Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> schrieb im Newsbeitrag
news:e22N7hw$(E-Mail Removed)...
> 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.
>
> However, Outlook 2003 does not show security prompts on three specific

types
> of applications:
>
> -- VBScript code in published, non-oneoff Outlook forms
>
> -- Outlook VBA code that uses the intrinsic Application object
>
> -- Outlook COM add-ins properly constructed to derive all objects from
> the Application object passed by the OnConnection event
>
> In earlier versions of Outlook, 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 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 and either your application

needs
> to support versions besides Outlook 2003 or your application runs extenal

to
> Outlook, you have these options for modifying your program to avoid the
> security prompts (roughly in order of preference):
>
> -- 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
> recommends. However, it applies only to COM add-ins and external programs;
> you cannot use Extended MAPI in Outlook forms or VBA.
>
> -- 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.
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Ivan Debono" <(E-Mail Removed)> wrote in message
> news:OKWRIao$(E-Mail Removed)...
> > Hi,
> >
> > I have wrote a little program in VB to send emails to contacts using
> > outlook. But everytime I send an email, a window pops up and I have to

> wait
> > 5 seconds, click Yes and then the email is sent.
> >
> > Is there a way to overcome this??
> >
> > Thanks,
> > Ivan
> >
> >

>
>



 
Reply With Quote
 
Sue Mosher [MVP-Outlook]
Guest
Posts: n/a
 
      1st Mar 2004
You can customize the Outlook toolbar to run any VBA macro by dragging the
macro from the Commands tab of the Customize dialog. See
http://www.slipstick.com/outlook/toolbar.htm#macro

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


"Ivan Debono" <(E-Mail Removed)> wrote in message
news:e3TTZt4$(E-Mail Removed)...
> I've got Outlook 2003. I've moved the code inside a macro, created a form,
> etc...
>
> Is there a way to access the form from an outlook button or something like
> that??
>
> Thanks,
> Ivan
>
> "Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> schrieb im Newsbeitrag
> news:e22N7hw$(E-Mail Removed)...
> > 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.
> >
> > However, Outlook 2003 does not show security prompts on three specific

> types
> > of applications:
> >
> > -- VBScript code in published, non-oneoff Outlook forms
> >
> > -- Outlook VBA code that uses the intrinsic Application object
> >
> > -- Outlook COM add-ins properly constructed to derive all objects

from
> > the Application object passed by the OnConnection event
> >
> > "Ivan Debono" <(E-Mail Removed)> wrote in message
> > news:OKWRIao$(E-Mail Removed)...
> > > Hi,
> > >
> > > I have wrote a little program in VB to send emails to contacts using
> > > outlook. But everytime I send an email, a window pops up and I have to

> > wait
> > > 5 seconds, click Yes and then the email is sent.
> > >
> > > Is there a way to overcome this??



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating Outlook Andrew Kennard Microsoft Outlook VBA Programming 1 20th Dec 2006 03:27 PM
Automating Outlook Howard Kaikow Microsoft Outlook VBA Programming 7 16th Jun 2005 03:37 PM
Automating Outlook and FTP using vb.net =?Utf-8?B?Sm9iIExvdA==?= Microsoft Dot NET 0 18th Jan 2005 05:31 AM
Automating Outlook =?Utf-8?B?RGVyZWtSb3Njb2U=?= Microsoft Outlook VBA Programming 1 8th Dec 2004 01:30 PM
Automating Outlook Jared Microsoft Outlook 3 2nd Mar 2004 07:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:40 PM.