If Outlook isnt open, when the macro run, it will prompt me some code address error.

click on debug , it point me to this line of code:

Set OutMail = OutApp.CreateItem(0)

Work when my outlook is open before excel run the macro.

Any idea?

Please Login or Register  to view this content.