Reference issue with Outlook

Hello All,

Does anyone know of a way to update the References to MS Outlook on a VBA Project upon open?

The issue I'm getting is a workbook currently uses MS Outlook to send an email at the end of a procedure, but when a user is on a pc with a different version of MS Outlook (10, the vb script errors when opening and complains about a "Missing MS Outlook Library".

I know it's easy enough to uncheck the Missing Library and check the required one manually - but my users are not that technical and I'd like to handle this error automatically (if its possible?).

Any help would be greatly appreciated.

P.s - I've even tried coding using Late binding - (see below), but I still get the same error (code works perfectly once the correct reference is checked)...!?

Thanks in advance.
Kurt

Please Login or Register  to view this content.

Norie,

Thanks - That's exactly what it was

As easy as that (I couldn't see the wood through the trees......!)

Thank you very much.