Well in the box i wrote the above i separated all of the items, quantity, took, reorder at and left. When it posted it jammed it all together. I hope you follow my meaning. It did look better then that.
Trying to send email when a cell gets to a certain value
I have searched the web for this and everything i see involves writing code. I have done anything like this so i need some help. I have a inventory sheet that has formulas in it to count down as items are used, these numbers are inserted. then the calculations take over. Here is a sample:
item quantity took reorder at left
THREADING LUBE STL8 12 TUBE 6 TUBE 12
Dark THREADING OIL 2 JUG 1 JUG 2
TAPPING OIL 2 TUBE 1 TUBE 2
Zinc 12 can 6 can 1
So as you can see they add in what they took, it will subtract from reorder column and the column will decrease. When the number left gets to the reorder number it will turn red, thats when i need a email sent out to three people to make sure that the new reorder goes in. Please help me in writing the right code and sticking it in the right locations.
Thank you
item quantity took reorder at left
THREADING LUBE STL8 12 TUBE 6 TUBE 12
Dark THREADING OIL 2 JUG 1 JUG 2
TAPPING OIL 2 TUBE 1 TUBE 2
Zinc 12 can 6 can 1
So as you can see they add in what they took, it will subtract from reorder column and the column will decrease. When the number left gets to the reorder number it will turn red, thats when i need a email sent out to three people to make sure that the new reorder goes in. Please help me in writing the right code and sticking it in the right locations.
Thank you
- Status
- Not open for further replies.
1 - 6 of 6 Posts
Didn't realize i could upload my file. Here it is if any one can help it would be great.
Attachments
-
12.6 KB Views: 4
I have just responded to post like yours here.
https://forums.techguy.org/threads/emailing-from-excel-on-certain-dates.1177806/
The only basic difference is that it is checking a date.
https://forums.techguy.org/threads/emailing-from-excel-on-certain-dates.1177806/
The only basic difference is that it is checking a date.
That sounds good, but I don't really know where to install it. Never done anything this before. I have read a lot about it, but no one really says insert this code here. Once i get it installed then maybe I can rewrite it to do what i need. Thanks.
Where you put it depends upon how you want the check to be done, the simplest method is to have a button that you click on to run the code.
You can also put the code in a procedure that runs when the workbook is opened.
You can also put it in a procedure that runs when cells are changed, but that requires slightly more code.
You can also put the code in a procedure that runs when the workbook is opened.
You can also put it in a procedure that runs when cells are changed, but that requires slightly more code.
1 - 6 of 6 Posts
- Status
- Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
