Send eMail from VBA stops in outbox if Outlook not opened - Microsoft Community

hi,

i've got excel macro save active sheet pdf , attach email.

since want user add comments mail, use ".display" instead of ".send".

the problem when user clicks send button, mail stored in outbox , not sent if outlook has not been opened before mail created.

if open outlook afterwards (maybe hour later or so), find mail in outbox , after sent in next minute or so.

i tried use ".send" in macro. works fine: mail sent immediately, need use ".display" ask additional user input.

is there macro command tell outlook "send that's in outbox"?

btw: we're using office 2013

this undoubtedly relates way outlook used when create outlook object vba

instead of creating outlook object - use code @ http://www.rondebruin.nl/win/s1/outlook/openclose.htm start outlook. copy blue bit below sub heading 'test code' new module in project , use syntax macro below get/create outlook object. should work if outlook had been open.

Office / Outlook / Windows 8