why doesn't this work anymore???

S

SuperMagnetMan

Set myolapp = CreateObject("Outlook.Application")

Ihave used this for years ni office apps to launch outlook from within excel
and word but now in the latest version it doesn't work. Is there something
else that has to be set to make this work? It produces the error "Type
Mismatch" which is, as usual, very helpful. I have the outlook reference
set, is there anything else required. Of course Ihave previously
dimensioned it as an application.

thanks
George
 
S

SuperMagnetMan

Dim myolapp As Application

That is exactly how it appears

George

Thoughts???
 
S

SuperMagnetMan

For reasons that absolutely escape me, the fix is to NOT Dim the object as
an Application. I commented out the line that dimensions the object and the
program worked perfectly like it is supposed to.

Thanks
George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

why this program doesn't work if Outlook is not manually launched? 4
redemption code doesn't work 8
how to disable security message in save attachments macro "A programis trying to access e-mail addre 5
Scraping outlook emails (2 questions) 1
Why do I get a type mismatch when trying to access mail items? 3
How to save attachment automatically in Outlook 2003? 17
Trying to run this macro to save Outlook mailbox folder list - but it doesn't work 1
Suddenly macro doesn't work 2

Top