Excel VBA - Button that sends email containing specific range of cells based on value

Koobetto

New Member
Joined
Mar 16, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,129,589
Messages
5,637,278
Members
416,963
Latest member
samfuge

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top