Home/ Questions/Q 10423
Next
Answered
computing
  • 7
Asked: 2021-12-05T23:48:54+00:00 In:

How To Get excel To Send Me An Email When a Due Date Arrives

  • 7

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.

Share

    1 Answer

    1. Best Answer
      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

      • 0