Sleeper: VBA to continuously click email hyperlink

[kan88]

Hi guys,

Can I know how to construct VBA script to continuously click all the hyperlink in rows that has instruction to send email?

I have attached an Excel sheet. When the hyperlink shows "send email", it will auto click all of it, then an Outlook mail will populate all the email details but need to click Send button.

30957

My Excel with send email instruction and email details:
https://docs.google.com/spreadsheets/d/1OKFHTS3H6I7HzaguXoqFlofuhTjq1Nd8/edit?usp=sharing&ouid=110283366946178978815&rtpof=true&sd=true

Thank you.

[June7]

You did not attach file, must be downloaded.

Follow instructions at bottom of my post to attach file.

You want code to 'click' each "Send Email"? Only the first one has expression with valid email address.

I don't know how to replicate cell click. Would be easy to loop email list and execute VBA FollowHyperlink method.

[Aflatoon]

Cross-posted: https://chandoo.org/forum/threads/vba-to-continuously-click-hyperlink.54361/

[Aussiebear]

Kan88, its very disappointing to see cross posting so early in the life of the thread, particularly when you failed to indicate that you've posted the issue elsewhere... The rule across almost every vba forum regarding cross posting is similar. When you gain a reputation for cross posting, it makes others unlikely to offer you further assistance, and you really don't want to be in that situation.

[Aussiebear]

Well I'm kind of not surprised. When a person is called out for cross posting.. as has Kan88, there are two clear options. Step up (which requires courage) and accept that you done wrong, or hide amongst the shadows. Sadly it seems Kan88 has chosen the latter, therefore you can hit the showers, you will not be asked to participate any further in the game.