L
little_rascal
Heya, I have this excel spreadsheet that store data of some licenses. The
fields consist mainly of the description of the license, expiry date, the
relevant party etc. Due to the fact that this spreadsheet serves as a source
of centralised information, a reminder is required to be generated when the
expiry date is nearing. The reminder is to be sent to the relevant party who
is supposed to carry out further action (i.e. renew) the license. Thus, I
need help on:
1) How to reflect (i.e. highlight) to the user of the excel spreadsheet that
the expiry date is nearing (let's say... a wk in advance)?
2) How to extract the particular row of information in the spreadsheet
together with the heading of the spreadsheet and send to the relevant party
for further action when the expiry date is nearing?
3) How to send the row of information as an email to the relevant party?
Thank you.
fields consist mainly of the description of the license, expiry date, the
relevant party etc. Due to the fact that this spreadsheet serves as a source
of centralised information, a reminder is required to be generated when the
expiry date is nearing. The reminder is to be sent to the relevant party who
is supposed to carry out further action (i.e. renew) the license. Thus, I
need help on:
1) How to reflect (i.e. highlight) to the user of the excel spreadsheet that
the expiry date is nearing (let's say... a wk in advance)?
2) How to extract the particular row of information in the spreadsheet
together with the heading of the spreadsheet and send to the relevant party
for further action when the expiry date is nearing?
3) How to send the row of information as an email to the relevant party?
Thank you.