+ Reply to Thread
Results 1 to 2 of 2

Automated Email Notification on Specific Date

  1. #1
    Registered User
    Join Date
    04-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Automated Email Notification on Specific Date

    Hi,

    I am not familiar with macro nor VB but I know this can be done somehow. I want to have an email send to a specific email address 2 or 8 months prior to the expiry date (In the email, I like to have it state the unit name as well). The "Expiry Date" column contains multiple dates for a specific group. I only want the last date in each group to have an email send 8 months prior to the expiration while the others to be 2 months. Attached is the template for it.

    I already set a conditioning format to those cell with this: AND(MONTH($G$26)-MONTH(TODAY())<=8,TODAY()-$G$26<=0,YEAR($G$26)=YEAR(TODAY()) and with the "next month" default conditioning format on the other cells.

    Any kind of clue on how to do this is appreciated. Thanks!testdates.xls

  2. #2
    Registered User
    Join Date
    03-30-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: How: Automated Email Notification on Specific Date

    I would also like too know how this can be done

+ 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