Add Outlook Referances in VBA

[ANP]

Hi Guys,

I have a database which is linking to Ms Outlook for Email messages and Appointments.

However, it needs to run on client machines which are running versions 2003, 2007 and 2010 of Office.

currently I am manually maintaining 3 versions each with the relevent referances checked manually. This is causing version control headaches.
References required = "Microsoft Office Outlook View Control" and "Microsoft Outlook 12.0 Object Library"

The Database already has conditional proccessind depending on Office version number.

Can this be extended to programmatically createing the referances ?

Regards

ANP

 

[jdraw]

You may get more info from this set of posts
http://www.access-programmers.co.uk/forums/showthread.php?t=209849

At least it is a starting point.
Good luck.

 

[darbid]

Office Version hell is a real problem. You should look at late binding then you do not have to worry about this. You do however have to test your code on each version to make sure you dont try a method or use a propoerty that that version did not have.

 

[gemma-the-husky]

note that you cannot change references programmatically in an mde/accde

late binding is certainly a solution.

if you don't mind paying a modest amount for a solution, then look at the outlook/email solution in wayne phillips everythingaccess site.