I have a basic macro to send an email when a criteria is met. I would like for it to only do this once. What do I add to the macro to update the spreadsheet so it will only send it once?
I am very new to this so looking for easy instructions. tks
>>> use code - tags <<<
I am very new to this so looking for easy instructions. tks
>>> use code - tags <<<
Code:
Sub Email_From_Excel_Basic()
Dim emailApplication As Object
Dim emailItem As Object
Set emailApplication = CreateObject("outlook.Application")
Set emailItem = emailApplication.CreateItem(0)
emailItem.to = Range("H11").Value
emailItem.Subject = Range("b2").Value
emailItem.Body = Range("b1").Value
emailItem.Send
End Sub
Last edited by a moderator: