how to get excel to send me an email when a due date arrives

November 3, 2014 at 23:57:15
Specs: Windows 8
I have an equipment list and I would like to be able to be prompted 1 week prior to the date that my calibrations are due without having to remember to check all the time.
Can you please help me set it up so that an email alert can be sent saying that a certain piece of equipment is due for calibration within 1 week.

See More: how to get excel to send me an email when a due date arrives

Report •

#1
November 4, 2014 at 06:36:58
I have only minimal skills with Macros but see if this site gives you some ideas:

http://www.rondebruin.nl/win/sectio...

MIKE

http://www.skeptic.com/


Report •

#2
November 4, 2014 at 21:12:02
I had a bit of a look but there is nothing really specific to what I am looking for and it might as well be written in a different language because I have absolutely no idea what them formulas were going on about.

Report •

#3
November 5, 2014 at 04:11:53
Sorry it wasn't of help.

Your question has been asked before and there should be a few threads on the forum that reference Email and Excel.

Hopefully someone with more macro experience will jump in.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
November 5, 2014 at 09:17:25
re: "it might as well be written in a different language because I have absolutely no idea what them formulas were going on about. "

The language is known as VBA - Visual Basic for Applications. It is the language used to write macros for Microsoft Office applications such as Excel, Word, PowerPoint, etc. When used within Excel, a macro allows you automate tasks as well as accomplish many other things that formulas can not do.

As a very simple example, try this:

1 - Open a new spreadsheet
2 - Enter some values in A1:A3. Numbers, names, formulas, whatever
3 - Right click the Sheet tab for the sheet and choose View Code
4 - Paste this VBA Macro into the pane that opens:

Sub MsgBoxCode()
'Loop through A1:A3, Show Value In Message Box
  For nxtRw = 1 To 3
    MsgBox "The Value In " & Range("A" & nxtRw).Address & " is " & Range("A" & nxtRw)
  Next
End Sub

5 - Click Run on the toolbar.

This simple macro is just an example of how VBA could be used to accomplish your email goal. Instead of using instructions to present a message to the users, instructions would be used to send an email based on some specified criteria.

This link shows some code that seems to be very close to what you would need. Obviously it will need some tweaking, but if the description of the task is very close to your requirements, let us know the details and we'll see what we can do.

http://forums.techguy.org/business-...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#5
November 5, 2014 at 12:45:13
Just FYI...

I tested the code found via the link I posted in my previous response and it works exactly as advertised but with one annoying issue.

When Excel tries to send the email(s), I get the following warning:

"A program is trying to send an e-mail message on your behalf. If this is unexpected, click Deny and verify your antivirus software is up-to-date."

I then have to wait until the progress bar reaches 100% before I can click Allow and have the email sent. If the Excel sheet is trying to send more than one email, I will have to wait and click Allow for each and every email.

My research led me to the following site which explains how to resolve this issue, but the solution will not work in my situation. I am using a Win7 PC with a locked-down corporate image. I cannot change the settings discussed at that link because I can not log in as an Administrator. This may or may not be an issue for you, but I wanted to point it out anyway.

http://www.msoutlook.info/question/883

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question