Change object library reference with VBA

Question

I manage several MS Access 2010 applications on 500+ computers which use the Outlook 14.0 Object Library to send email reports and notices.  Our corporate IT recently notified me that all new PCs installed here will be running Office 2013 so I am anticipating a problem with those systems not working with the current Outlook library.  Is there a way via VBA to set the correct library reference based on the version of Office running the Access app?

Mike...

Answer 1

ciao Mike,

I suggest to change the reference from early binding to late binding...

take a look a this :

http://stackoverflow.com/questions/19184650/late-binding-to-open-outlook-from-access

with late binding no need to worry about that specific library/office version.

ciao, Sandro.