VBA Send Email based off cell value

[nivster]

Hi everyone!

I am not familiar with VBA at all, so I'll appreciate all responses

I am trying to send an email address based off the cell value in my excel sheet. The body of the email will change depending on what the value is. If the value is under $0, the body of the email will be different than if it is over $0.

I tried looking for if then examples, and see if those would work but I'm not sure if this is the best solution.

I'd appreciate any information or steps that would help me get this

 

[Koleyd]

HI There,

I am also a novice with VBA. I'm working with an existing script, and have to have a check in place to stop an email from sending if all the criteria isn't met. It all works for the simplistic stuff. And I am sure that the solution to this is as simple as can be, but my brain just doesn't think this way. Below is the code that's tripping me up. Basically what I need the 'if' to do, is check the value in cell A9 is equal or greater than 1 but less than 7 and exit the sub. If the cell is empty "" or '0' to allow the script to run or resume next. Is there a way to do this? Or am I dreaming?

Any assistance would be greatly appreciated.

ElseIf Sheets("Amendment").Range("A9") >= 1 < 7 Then
MsgBox ("Please complete LINE 9 in full before proceeding.")
Exit Sub

 

[Michael M]

If Sheets("Amendment").Range("A9") >= 1 AND Sheets("Amendment").Range("A9") < 7 then ...

 

[Koleyd]

OMG, was it really that easy? Thank you Michael! very much appreciated.

 

[Michael M]

Glad to help....??