In column E of my spreadsheet, I have programmed some logic in to the cell that compares 2 values, and chooses which hyperlink is available to the user. If the condition is true, the hyperlink goes to a folder directory where there is no additional programming needed. If it is false, the hyperlink opens an Outlook Template where the user can send me an email.
I was hoping to pass the value of column A and B as variables and output it with the instance of the Outlook email template.
I've fidgetted around with the FollowHyperlink event with little success. I can't even get the event to fire. Something that concerns me is that maybe the FollowHyperlink is unavailable when the Hyperlink() function is nested or maybe it has something to do with 2 hyperlinks within 1 cell.
Here is my formula in E:
=IF(C2>=D2, HYPERLINK("j:\forms\election\"&TEXT(TRUNC(TRIM(A2)/1000)*1000,"0000")&"-"&TEXT(TRUNC(TRIM(A2)/1000)*1000+999,"0000")&"/"&LEFT(TRIM(TEXT(A2,"0000")),2)&"00s/"&TEXT(TRIM($A2),"0000")&"/election","click here to find the updated form yourself!"), HYPERLINK("J:\Forms\Election\Form Database\request.oft","click to request updated forms!"))