Excel email notification by date

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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
 

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
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.
 

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.
 

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
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 ?
 

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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top