I just found out the hard way that Access 2007 and ClickYes don't play well
together. More than a few of us use ClickYes as a work-around for the
annoying pop-up messages from Outlook when trying to send emails from Access.
The free version of ClickYes does not support Access 2007. ClickYes Pro ($20)
does; however, I had an error using it.

If you depend on ClickYes to help send emails out of Access through Outlook,
you might want to hold off on upgrading to Outlook or Access 2007.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Better yet, rewrite your code to use Outlook 2007 objects directly. External automation code is trusted by default in Outlook 2007 if the client system has active and up-to-date anti-virus protection.

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

"Jerry Whittle" <(E-Mail Removed)> wrote in message news:4C95D763-4736-4162-BE25-(E-Mail Removed)...
>I just found out the hard way that Access 2007 and ClickYes don't play well
> together. More than a few of us use ClickYes as a work-around for the
> annoying pop-up messages from Outlook when trying to send emails from Access.
> The free version of ClickYes does not support Access 2007. ClickYes Pro ($20)
> does; however, I had an error using it.
>
> If you depend on ClickYes to help send emails out of Access through Outlook,
> you might want to hold off on upgrading to Outlook or Access 2007.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
Better yet, rewrite your code to use Outlook 2007 objects directly. External
automation code is trusted by default in Outlook 2007 if the client system
has active and up-to-date anti-virus protection.

Very cool answer!!...did not know that!!

Of course outlook should be trusted by ms-access. What a terrific
solution!!! No more nags!!! Fantastic news!!!

I feel better already.....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

"Albert D. Kallal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> Better yet, rewrite your code to use Outlook 2007 objects directly.
> External automation code is trusted by default in Outlook 2007 if the
> client system has active and up-to-date anti-virus protection.

Can you expand on the above?

Question:
Is this trust for all scripts and applications that automate outlook, or is
it just the fact that outlook will *trust* ms-access, and other office
programs? (it makes sense to trust ms-access...but, not some .exe you
download in a email!!!).



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

Outlook 2007 permits external automation without security prompts by any application, as long as the client machine has adequate anti-virus protection. This applies *only* to code that uses the Outlook object model, not Simple MAPI, CDO, or other automation related to Outlook.

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

"Albert D. Kallal" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> "Albert D. Kallal" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> "Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> Better yet, rewrite your code to use Outlook 2007 objects directly.
>> External automation code is trusted by default in Outlook 2007 if the
>> client system has active and up-to-date anti-virus protection.
>
> Can you expand on the above?
>
> Question:
> Is this trust for all scripts and applications that automate outlook, or is
> it just the fact that outlook will *trust* ms-access, and other office
> programs? (it makes sense to trust ms-access...but, not some .exe you
> download in a email!!!).

"Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
Outlook 2007 permits external automation without security prompts by any
application, as long as the client machine has adequate anti-virus
protection. This applies *only* to code that uses the Outlook object model,
not Simple MAPI, CDO, or other automation related to Outlook.

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


Thanks..that helps a whole lot!!

That is a darn good clear answer from you!!

It is wonderful to see that my strong belief that automation in office is
what gives it so much value, and this represents a nice movement in terms of
us office developers.....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

I agree that this is a big win for Outlook developers and Office integration. It's been a long time coming

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

"Albert D. Kallal" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
>
> It is wonderful to see that my strong belief that automation in office is
> what gives it so much value, and this represents a nice movement in terms of
> us office developers.....