Running a macro from an outlook hyperlink/email body

[orangestripes]

Hi,

I have a spreadsheet that other users use to add records to a simple table, and when they do there is vba code that generates and sends an email to managers. The email has a hyperlink to the spreadsheet in the body, but I would like the link to not just open the spreadsheet but run a macro too so that the record they have been emailed about will be loaded up in a viewing form for them. Is this possible?

 

[Anthony47]

And your managers really click any link contained in the emails they receive?