Hi, I was trying to run a macro when an email is received from a specific sender. Once that happens and the macro is triggered, I'd like it to open a hyperlink within the body of that email based on the display text of the hyperlink (since there are multiple hyperlinks, I only want to open the 1 link that has the display text of "Approve"). Once this link opens, it opens another email where I have to press send. I would also like it to send this new email that pops up automatically.

Does anyone know how this can be accomplished? Please let me know, thanks.