+ Reply to Thread
Results 1 to 4 of 4

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

  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

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

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

    This is a good resource for learning how to email from Excel:
    http://www.rondebruin.nl/sendmail.htm
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

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

    Quote Originally Posted by alexnkc View Post
    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.

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

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

    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

  5. #5
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

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

    All the info you need is on RdB's site, if CDO will work for you, it's the best for maintenance:
    http://www.rondebruin.nl/cdo.htm

+ Reply to Thread

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