+ Reply to Thread
Results 1 to 2 of 2

Reminder Mail Trigger Criteria Based

  1. #1
    Forum Contributor
    Join Date
    02-27-2015
    Location
    United Arab Emirates
    MS-Off Ver
    2013
    Posts
    147

    Reminder Mail Trigger Criteria Based

    Dear Experts,

    I need a solution for a day to day activity where a particular column to be read and accordingly a reminder mail to be sent with a Subject and body of the message in outlook mail. (In total 2 Reminder Mails - One at Day 60 and other at Day 29). But in case if the Status (Column H) is "Completed". Then Reminder mail should not trigger irrespective of days.

    To check the Days remaining to review Column (Column M),

    1. If the day reaches 60 days - a reminder mail to be sent to the person as per Email ID (Column F). Subject of the mail - (Column N) and Body of the Mail - (Column O). - Only One Reminder.

    2. If the day reaches 29 days - a reminder mail to be sent to the person as per Email ID (Column F). Subject of the mail - (Column N) and Body of the Mail - (Column P).
    Attached Files Attached Files
    Regards,

    Fareed

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,552

    Re: Reminder Mail Trigger Criteria Based

    Not sure is this what you want,

    Please see attached sheet Example 1, 2

    You can change date criteria on cell D1 and E1.
    Attached Files Attached Files

+ 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. [SOLVED] Automatic Outlook mail due date reminder based on Excel file
    By iamitp in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-18-2019, 05:51 PM
  2. Automatic Outlook mail due date reminder based on Excel file
    By billrigsby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2018, 11:02 AM
  3. Automatic Outlook mail due date reminder based on Excel file - REVISITED
    By billrigsby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2018, 11:48 AM
  4. [SOLVED] Macro modification - Trigger for pop up reminder
    By SVTF in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2014, 08:10 PM
  5. Hide/Unhide row based on given criteria w. no Trigger butn
    By m1zz13 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2013, 06:31 AM
  6. Set Reminder mail from Excel
    By KDPRASAD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2012, 03:23 AM
  7. [SOLVED] How can I get a date in exel to trigger a reminder in 30 days?
    By tigerfan in forum Excel General
    Replies: 0
    Last Post: 03-13-2006, 07:15 PM

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