Create macro program to automatically email outlook with a visible cell range

[BillMaintenance]

I am trying to email when my inventory gets to a minimum count when the visible cell gets data in it to a group to inform them that parts must be ordered. I will attach the entire program, if I can, to show the work I have done. I have studied a little from the internet, but cannot get it to work, I have not had any Excel courses for 6 years and I am afraid I forgot a lot about setting up Macros.