+ Reply to Thread
Results 1 to 2 of 2

Automatic Email Sending from excel

Hybrid View

elyas91 Automatic Email Sending from... 01-29-2021, 05:16 AM
Kaper Re: Automatic Email Sending... 01-29-2021, 09:34 AM
  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Kuala Lumpur
    MS-Off Ver
    MS Office 2019
    Posts
    28

    Automatic Email Sending from excel

    Hello my expert friends.
    Here is my problem. I am in the midst of building a risk matrix model, and I have set my probability of failure as a function of time using excel formula. Basically this formula allows the variable of my cells to dynamically change with each passing day. Now I don't want to be opening my workbook everyday to check if my values have reached a certain value, let's say for the sake of this example (=10). Instead what I would like to have is an automated reminder that sends me an email as soon as any of the values of the cells in the column reaches that said threshold of 10. And it has to be done repetitively each time any of the cells in the column (Let's say for the sake of example, Column C, RANGE C1:C40) reaches the threshold value of 10.

    I would appreciate any input on this matter, guys

    Thnx!!

    reminder.PNG

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Automatic Email Sending from excel

    But will this workbook with the model remain opened on some computer (working 24/7 ?) If so you can combine OnTime method with some mailing scripts (like such one https://www.rondebruin.nl/win/s1/outlook/amail2.htm )
    In OnTime two actions shall be scheduled - checking if threshold (10) value is met and then running mailng script, and setting new firing time for next OnTime event
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sending automatic email with Excel Macro
    By sudeep19 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2019, 02:42 AM
  2. Sending Automatic Email (CDO) with an Image
    By nicola.nicola in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2013, 01:20 PM
  3. [SOLVED] Excel Automatic Email Sending
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2013, 02:30 AM
  4. Replies: 0
    Last Post: 11-13-2011, 06:57 AM
  5. Automatic sending email
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-19-2011, 03:37 AM
  6. [SOLVED] Sending an automatic email from a spreadsheet
    By ghostly1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-24-2007, 06:43 AM
  7. Sending automatic email + Bloomberg
    By freddie mac in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-12-2006, 08:00 AM

Tags for this Thread

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