I have an Excel macro for creating and sending an Outlook email message using CDO. There's a reference to "Microsoft CDO 1.21 Library". The code starts the session with:
Set objSession = CreateObject("MAPI.Session")
Then it creates the message and runs:
objMessage.Update
objMessage.Send showDialog:=False
objSession.DeliverNow
The message goes to the Outbox and sends okay if Outlook is running. If Outlook is closed, the message goes to the Outbox but stays there until I start Outlook. I need it to send when Outlook is closed. How do I do this?
Thanks for the help.