Automatic send email (without even click send in mail software) with excel vba ??

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

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.

Please Login or Register  to view this content.

Hi,

Thanks Cheeky Charlie & AlphaFrog for your reply.

By removing IngResponse, vbYes and End If. when specific criteria meet, email prepared automatically and by just click "send", target group of people will receive the mail.

How about when specifit criteria meet, email prepared automatically and will send automatically as well to target group of people (without even need to click "send", then the email only sending out)? Is VBA able to do that??

BR
KC