Send e-mail alert based on Excel cell value? 2

[meghan95]

Does anyone know if it's possible to send an e-mail alert when a number on an Excel spreadsheet reaches a certain amount? It would be used in the following type of example: the bookkeeper keeps track of daily cash balances. If the balance in a cell is less than 100,000, I would want an e-mail to let me know.

I'm not very familiar with Visual Basic, but I'm sure there's some sort of solution.

Thanks, Meghan

 

[sawedoff]

You can get Excel to email you with this:

Sub auto_open()
If Range("c6&quot > 1000 Then
Sheets("Sheet1&quot.Select
ActiveWorkbook.SendMail Recipients:="recipient@server.com", Subject:="Whatever you want the subject line to say"
End If
End Sub

It wil run automatically when the file is opened. If you don't want it to run then, you should name it something other than auto_open, but then it will have to be run before exiting to email you. You could create a button that would run it and then save and close the file.

Sawedoff

 

[meghan95]

Awesome-star for you! Thank you so much - I'm really going to win some points with my boss for this one. I'm assuming if I want the e-mail to be sent when the worksheet is closed, I can just change auto_open to auto_close.

 

[sawedoff]

That should do it. Glad it helped. Thanks for the shiny thing.

Sawedoff