i am trying to use active.workbook.sendmail in my macro to send a workbook.
it pops up a window that says "A program is trying to automatically send emails on your behalf.... etc."
when i reply "yes", the program runs and terminates normally. when i reply "no", "a runtime error '1004' general mail failure" occurs.
excel.exe remains in the memory and when i try to open the excel spreadsheet again, it shows "file in use" and I need to go to task manager to end the process.
tried "on error resume next" but dont seem to work.
wud greatly appreciate assistance on this matter.
my objective is to trap the error and allow excel.exe to be released from memory and the program to close normally without error.