microsoft access automation to outlook version 2003 compared with 2000

[Philip Leduc]

Hi there,

I am an MS Access programmer using automation to connect Access to outlook.
I want to install the new office 2003 but it will overwrite outlook
2000(while keeping the option open to leave a version of the other programs
like word, excel, access).

Can anybody tell me what the prohability is that my VBA automation code
connecting with the 2003 outlook from the 2000 Access will still run. I use
the code for example to send e-mail from access (even with service pack 3
installed using clickyes) and throwing my contacts in newly created
different folders in the main contact folder.

I know that new tools exist to connect to word and excel with .net but I
remember as well from the office 2003 prezentations that you should still be
able to use VBA as well.

Philip

 

[Ken Slovak - [MVP - Outlook]]

Your code will still work the same as before with a few new
limitations. Outlook doesn't support the new VBA.Net, only Word and
Excel do.

In Outlook 2003 some new properties have been restricted, such as
..Body. And in Outlook 2003 by default all Outlook VBA code is
inherently trusted, but that won't apply when the code is run from
Access. See the "Revised and Improved Security Model" in the article
at
http://msdn.microsoft.com/library/d...n-us/odc_ol2003_ta/html/odc_OLWhatsNew2k3.asp
for more information.

I'm not sure how you'd use ClickYes with all that, most of us use
Redemption instead (www.dimastr.com/redemption)