https://www.mrexcel.com/forum/excel...acro-capture-mouseclick-excel-sheet-cell.html
I have a similar but different need.
I have a worksheet with where email reminders need to be sent out at six months and two months before renewal date
Column I
I have a formula that returns the numbers of days remaining in Column I
Column J
I have the a formula in column J to create a mailto link which when clicked creates an email in Lotus Notes if criteria is met. See below)
=IF(AND($I3>=60,$I3<=197),HYPERLINK("Mailto:"&$J1&"?subject="&$H3&"&body="&$B3&"Due in"&I3&" Days","Send Mail"),"")
Column K needs to be populated with code, Six Month Reminder Sent
I have a formula in Column L to display Mailto link if two reminder is due
=IF($I4<=60,HYPERLINK("Mailto:"&$J2&"?subject="&$H4&"&body="&$B4&"Due in"&K4&" Days","Send Mail"),"")
Column M needs to be populated wit code when two Month Reminder Sent.
I am using clickable links because I could not get any code to directly send emails via Lotus Notes.
This is my fall back plan.
Is it possible to get the code to enter a label in the offset column (same row) when the links are click to enter send status for me automatically?
All the articles I found are assuming links are IE links or Links to cells in the workbook.
Thank you kindly to anyone who can help.
Penny
I have a similar but different need.
I have a worksheet with where email reminders need to be sent out at six months and two months before renewal date
Column I
I have a formula that returns the numbers of days remaining in Column I
Column J
I have the a formula in column J to create a mailto link which when clicked creates an email in Lotus Notes if criteria is met. See below)
=IF(AND($I3>=60,$I3<=197),HYPERLINK("Mailto:"&$J1&"?subject="&$H3&"&body="&$B3&"Due in"&I3&" Days","Send Mail"),"")
Column K needs to be populated with code, Six Month Reminder Sent
I have a formula in Column L to display Mailto link if two reminder is due
=IF($I4<=60,HYPERLINK("Mailto:"&$J2&"?subject="&$H4&"&body="&$B4&"Due in"&K4&" Days","Send Mail"),"")
Column M needs to be populated wit code when two Month Reminder Sent.
I am using clickable links because I could not get any code to directly send emails via Lotus Notes.
This is my fall back plan.
Is it possible to get the code to enter a label in the offset column (same row) when the links are click to enter send status for me automatically?
All the articles I found are assuming links are IE links or Links to cells in the workbook.
Thank you kindly to anyone who can help.
Penny
