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


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Dim ol As Object
Set ol = CreateObject("outlook.application")
Call ol.sendtasks


HTH,
Bernie
MS Excel MVP


"Atishoo" wrote in message
...
I have a macro that will only run in outlook, is it possible to open outlook
and trigger that macro ("sendtasks") from excell?