|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:
'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)
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.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03