PDA

View Full Version : Call Outlook Macro form Excel



Subir
01-27-2014, 03:12 AM
I want to run outlook macro from excel, is it possible.

Subir

westconn1
01-27-2014, 03:55 AM
is it possible.yes

add a reference to outlook or late bind outlook, set or create an object, login if required

objol.test
where objol is an instance of outlook, as created above
and test is a Public sub in the Thisoutlooksession code pane
not tested in later versions of outlook
macro security level must be set accordingly or macros will not run