Hello all,
I am trying create an VBA script which will go through all cells in range H2:H210. When condition is met, VBA should execute a function which is written in that specific cell. Function is hyperlink to send customized email.
Example of this hyperlink:
INDEX($N$2:$N$10 >>> list of emails
;MATCH(F12 >>> surname
;$M$2:$M$10 >>> list of surnames
;0))
I am struggle only with this iniciating sequence of VBA. I can't force VBA to execute function stored in cell.
At this moment I have to manually click on cell in which condition is met. When I clicked on cell (hyperlink "reminder"), email is send nice and easy.
One more issue... It's possible to run VBA in following manner:
Within VBA condition is met, hyperlink in that specific cell is trigger, email is send.... then VBA will continue in looping process in this manner until end of range
I am trying create an VBA script which will go through all cells in range H2:H210. When condition is met, VBA should execute a function which is written in that specific cell. Function is hyperlink to send customized email.
Example of this hyperlink:
Excel Formula:
HYPERLINK("mailto:"&INDEX($N$2:$N$10;MATCH(F12;$M$2:$M$10;0))&"?subject="&"Expiration of "&A12&"&body="&A12&" - "&B12&" >>> projekt: "&C12&" ("&D12&") %0A is due to exprirate on "&TEXT(J12;"dd.mm.yyyy")&"%0A%0ABest regards";"reminder")
INDEX($N$2:$N$10 >>> list of emails
;MATCH(F12 >>> surname
;$M$2:$M$10 >>> list of surnames
;0))
I am struggle only with this iniciating sequence of VBA. I can't force VBA to execute function stored in cell.
At this moment I have to manually click on cell in which condition is met. When I clicked on cell (hyperlink "reminder"), email is send nice and easy.
One more issue... It's possible to run VBA in following manner:
Within VBA condition is met, hyperlink in that specific cell is trigger, email is send.... then VBA will continue in looping process in this manner until end of range