Calling Outllok macro from excel

[jc113883]

Hello,

How can I call an Outlook macro from excel?

If I am controlling Excel from Outlook, I can use:

set XLApp = getobject(,"excel.application")
xlapp.run ("Macro1")

But Outlook does not use the run method.

Cheers,
Graeme.

 

[Derek Brown]

Don't have the answer that you are looking for but I would consider either (a) performing the Outlook functions from Excel [in effect having the macro in Excel] or (b) [never tried this so not sure if it will work] creating a Form in Outlook with a button to run the macro, and loading the form from Excel VBA.

 

[thelarster]

JC - did you ever get an answer to this? I am trying to do the same thing.

Thanks,

 

[jc113883]

No, sorry.