Results 1 to 5 of 5

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

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    66

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1