Object Library not supported (Outlook VBA)

I have some VBA code in Access that creates emails in Outlook.

Public objMail as Outlook.MailItem

Set objMail = Outlook.Application.CreateItem (olMailItem)

This compiles and runs fine on one PC.

However, if I copy the Access file to another user's PC they can not run the code and get the error:

Compile error: Object library feature not supported

The objMail in the Set line is highlighted.

I have checked References and they are all the same on both PCs.  We have also reinstalled Office on the offending PC.

Please explain what's going wrong and what's needed to fix.

Thanks

Laurence
LJKMartinTraining DirectorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewIT / Software Engineering ConsultantCommented:
Check the full list of reference on both computers, as well as the order of referenced libraries.  It may be that some other library, or the ordering being different could have an impact.

No idea if this might apply for you, but try renaming the procedure, and then renaming it back as mentioned in this 'interesting' thread...

Object library feature not supported (anymore) :( ...


»bp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.