Goodevening,
I am trying to make some coding in VBA for a certain excel file containing due dates, for which I would like to press a button in the sheet that checks two specific columns for values (remaining days - columns L and P) to be < 15, then sends an email to a specific recipient containg the number of days remaing and some data present on the same row as the one containing that specific value (< 15).
So far I haven't made much but to display the outlook window that sends and email, mostly because I'm not very good at coding in VBA and because I have found only similar problem solutions on the forum.
Could you please help me? In the below like you can find the file I am working on:
I have done just a few by adapting some code I found on the web. Right now it checks only one cell (L3) for the value to be < 15, if so it calls the new sub and proceeds to display the email. What I would like is to fill the email body with the cells in the column L that are < 15, and in the same row of that cell , the value of colums D, G, J, K.
Then if possible, with the same button it should do the same thing with column P.
Please feel free to ask any further details. Thanks in advance
I am trying to make some coding in VBA for a certain excel file containing due dates, for which I would like to press a button in the sheet that checks two specific columns for values (remaining days - columns L and P) to be < 15, then sends an email to a specific recipient containg the number of days remaing and some data present on the same row as the one containing that specific value (< 15).
So far I haven't made much but to display the outlook window that sends and email, mostly because I'm not very good at coding in VBA and because I have found only similar problem solutions on the forum.
Could you please help me? In the below like you can find the file I am working on:
I have done just a few by adapting some code I found on the web. Right now it checks only one cell (L3) for the value to be < 15, if so it calls the new sub and proceeds to display the email. What I would like is to fill the email body with the cells in the column L that are < 15, and in the same row of that cell , the value of colums D, G, J, K.
Then if possible, with the same button it should do the same thing with column P.
Please feel free to ask any further details. Thanks in advance
