VBA: Call Outlook Macro From Excel. Object Does not support property or method

Question

I am trying to call a public macro stored in ThisOutlookSession from an excel macro. The outlook is open at all times.

I found the following: Call outlook VBA from Excel

My excel code:

Set myOutlookApp = GetObject(, "Outlook.Application")
If Not myOutlookApp Is Nothing Then myOutlookApp.ReadEmails

On the second line i get an error:

Run-time error '438': Object doesn't support this property or method

Your help is greatly appreciated.

Have you tried making the subroutine 'ReadMails' public? – Aug 17 '18 at 11:32 — , Aug 17 '18 at 11:32
@bub yes i mentioned above that it's public – Kelaref Aug 17 '18 at 13:31 — Kelaref, Aug 17 '18 at 13:31

score 1 · Accepted Answer · answered Aug 17 '18 at 15:21

1

You cannot access Outlook macros using syntax like Application.YourFunctionName. You will need to convert your Outlook VBA code to an Excel VBA script.

answered Aug 17 '18 at 15:21

Dmitry Streblechenko

57,446
3
49
77

VBA: Call Outlook Macro From Excel. Object Does not support property or method

1 Answers1