+ Reply to Thread
Results 1 to 2 of 2

Excel Macro to send notification email when items pass a certain date

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Guildford (Offshore)
    MS-Off Ver
    Excel 2013
    Posts
    1

    Lightbulb Excel Macro to send notification email when items pass a certain date

    Hi all,

    My first post on this forum, which so far has helped no end, however i have a requirement for something a little more complicated than i am used to.

    I have a iventory of PPE (personal protective equipment), each of these items have separate (some the same) dates where checking or recertification is required, I would like to set up a system that will allow an automatic marco to run when opening the workbook to flag items within a certain date (example 1 month before an item goes out of date) and send a notification email with the item, its location and its unique number. An example of what my information looks like is below (hopefully).

    Any help would be appreciated, I think it may be a useful tool for others too.

    Best Regards,

    Krist87

    PPE.xls

  2. #2
    Forum Contributor gsnidow's Avatar
    Join Date
    07-22-2010
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    150

    Re: Excel Macro to send notification email when items pass a certain date

    Krist87, if you are using Outlook, you could do something like the below. I did not spend too much time trying to determine what time frame should warrant an email, as you should be able to easily do that. One thing you need to watch out for, is that all dates are in the same format. There are some that are dmy, then some that are mdy. Anyhow, let us know if you have any questions.

    Please Login or Register  to view this content.
    Greg
    Last edited by gsnidow; 01-08-2014 at 09:12 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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