Originally Posted by
alexnkc
Hi,
Currently I have a worksheet (attached excel file) which able to trigger send-email-sub macro when specific criteria meet.
Refer to attached excel file -
When value on D5:D6 is smaller then E5:E6, msgbox will show and if Yes was choose, it will go to email (outlook or Thunderbird or Hotmail). Then just click send and the email will send to email address which show in I5:I6.
So is it possible to ignore above step, which mean When value on D5:D6 is smaller then E5:E6, email will automatic send (even without click send button in email (outlook or Thunderbird or Hotmail)?
BR
KC
- Alt+F11 to open the VBA Editor
- Double-click on ThisWorkbook in the upper left VBA Project window.
- Replace the code in the edit window with the code below. Just the three green lines have been commented out.
Bookmarks