1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel email notification by date

Discussion in 'Business Applications' started by thomaswba, Aug 24, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. thomaswba

    thomaswba Thread Starter

    Joined:
    Aug 24, 2010
    Messages:
    3
    Hi guys, new users here!

    I have an existing work book containing 4 tabs all with multiple columns.
    The information contained within this workbook is a maintenance schedule for repairs on air conditioning for a few thousand different sites.
    The cells in question simply contain a "1" in the relevant month column as to when the maintanence is due.

    I currently use very basic conditional formatting to change the colours of the cells if the maintenance is due this month, overdue last month, or a warning if a maintenance is a week away from being due.

    (NOTE: I'll refer to the maintenances as PPM's)

    It has become imperitive that I find a better way to track overdue PPM's, my director has asked if there is a way we can send an email notification (just to one person if needs be) if the date in the cell has become overdue / due that day.

    I have very little experience with VBA but I have played around with Python and Java so programming isnt completely new to myself.

    Anyone that can provide any help would be greatly appreciated!!

    Regards,

    Tom
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    Hi, welcome to the board,

    It's not the answer to your question but it is some guidance on how to mail using excel
    http://www.ozgrid.com/VBA/send-email.htm

    If you post a small sample with ficticious data and some example of situations with what you want to send, I'm sure some of us can come up with something.
     
  3. thomaswba

    thomaswba Thread Starter

    Joined:
    Aug 24, 2010
    Messages:
    3
    Here is a screenshot of some test data:

    http://www.glowfoto.com/static_imag...age/24-022427L/2738/jpg/08/2010/img5/glowfoto

    As you can see the site address and details are listed on the left hand side, the columns following that are simply the months of the year.

    The "1" in a cell represents a maintenance that is due. Ignore the colour coding for now.

    We are looking to change the "1" to a date making it easier not only for conditional formatting but also the email notification issue.
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    How does the "1" get there? Do you do that using a formula? Then you already have something that relates to a date, how else would you know its Oct or Nov ?
     
  5. thomaswba

    thomaswba Thread Starter

    Joined:
    Aug 24, 2010
    Messages:
    3
    The "1" is a manual input and is likely to change position.

    This represents when the maintenance is planned to be completed.

    As I said we are looking to replace the "1" with a date; A. to be more accurate, B. to try solve this issue.

    Thanks again
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/945306

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice