Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2016
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile How to send auto reminder when approaching a date in excel

    Hi,

    I have a task which needs to send auto reminder to myself when approaching to the expiry date (cell J2 and J3).

    Is this possible to be done? I am using outlook 2013 and excel 2013.

    thanks in advance.



    Test.xlsx
    Last edited by vvzz11; 2016-04-18 at 20:56.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts
    Hi

    Welcome to the Lounge as a new poster.

    This can be done in many different ways e.g. you could use the Windows scheduler.
    Or you could use an automated macro to check dates etc whenever you 'opened' the workbook.
    Or whenever the relevant sheet was activated.
    Or checking 'on demand' (by clicking a macro button).

    How often is the workbook updated?
    How often is the workbook opened?
    If a reminder email has already been sent, when would you want a second (third?) reminder sent???

    zeddy

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 645 Times in 589 Posts
    vvzz,

    Here is your revised worksheets that sends email reminders a specific number of days prior to your selected base date. A comment of when the email was sent will be placed in the column of your choice on the record. If "Inhibition" is set to true, the comment will also serve as an indicator that an email was already sent. So, if the code is run again, the email will not be repeated for that record. To resend the email, either set "Inhibition to False or remove the comment.

    vvzz6.png

    Clicking on the Configuration button opens a form allowing you to customize the email settings.

    vvzz4.png

    The help button opens a comprehensive guide to setting the configurations.

    vvzz5.png

    This is a sample of the sent email reminder

    vvzz3.png

    Let me know if you have any questions. I will be happy to help

    Maud
    Attached Files Attached Files

Posting Permissions

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