Ron de Bruin wrote

Hi Jignesh

Try this

ToolsOptionsMail Setup in the Outlook menu.
"send immediately when connect" in the options.


I've got that option checked in Outlook 2000. I have the same experience as
the OP. Unless I open Outlook, mail is not sent from Excel. Once Outlook is
opened, file appears briefly in Outbox, then gets sent.

--
David