0

Possible Duplicate:
Call outlook VBA from Excel

I know about the Application.Run method from Excel, with which I can open an Excel macro from Outlook.

I need to switch the Excel.Application object to Outlook.Application and it doesn't work.

The error message is: "Method is not supported."

Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
MrPropper
  • 3
  • 1
  • 2

1 Answers1

1

According to this thread, the only way to do this is to call a procedure stored in ThisOutlookSession:

Set myOlApp = CreateObject("Outlook.Application")
myOlApp.MyProcedure

However, this seems unsupported by MS.

JimmyPena
  • 8,694
  • 6
  • 43
  • 64
JMax
  • 26,109
  • 12
  • 69
  • 88