Send email notification on excel based on cell value

[Tariq384]

I have one question please and seeking your help

I need to set vba code to send email notification from excel

i have send mail formula and i can click the hyper ling and send the email by two clicks.

now what i need just vba to click the hyperlink and send button once the previous cell is update on each column

appreciate your help

 

[rondeondo]

there's an old clunky way of pressing buttons in other applications, called sendKeys.
As for clicking the hyperlink, you can always record a macro to find the code needed to achieve what you want. I often do that if I'm struggling with something that is "Just a simple click"