A Atishoo Oct 26, 2009 #1 I have a macro that will only run in outlook, is it possible to open outlook and trigger that macro ("sendtasks") from excell?
I have a macro that will only run in outlook, is it possible to open outlook and trigger that macro ("sendtasks") from excell?
B Bernie Deitrick Oct 26, 2009 #2 Dim ol As Object Set ol = CreateObject("outlook.application") Call ol.sendtasks HTH, Bernie MS Excel MVP
Dim ol As Object Set ol = CreateObject("outlook.application") Call ol.sendtasks HTH, Bernie MS Excel MVP
B Bernie Deitrick Oct 26, 2009 #3 The macro Sub sendtasks() 'code 'End Sub must be in either Outlook's default project or in the ThisOutlookSession's codemodule. HTH, Bernie MS Excel MVP
The macro Sub sendtasks() 'code 'End Sub must be in either Outlook's default project or in the ThisOutlookSession's codemodule. HTH, Bernie MS Excel MVP
