Good Afternoon,
Can someone please show the code for a problem I am having. I am trying to send an email automatically when a button is pressed on a form. I have tried

Sub roundedRectangle4_Click()
ActiveWorkbook.SendMail Recipients:="name email", Subject:="Event"

This bit is Ok, but when I try to add the hyperlink in Cell e12 it does not work. The hyperlink changes from time to time, so it really just needs to be the contents of cell E12.

Many thanks in anticipation.

robbosan