• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro email not to repeat


New Member
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 <<<
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
End Sub
Last edited by a moderator:

Marc L

Excel Ninja
As I'm very new about guessing anything so according to forum rules you must​
first edit your post in order to use the code tags via the 3 dots icon​
then well elaborate at least your need with all the necessary details …​