kc5sdy
New Member
- Joined
- Jul 21, 2004
- Messages
- 9
Please bare with me. My knowledge of Excel and what it can do only rivals the intelligence of dirt. I am in need of a lot if help.
I have a spreadsheet that shows the inventory I have in my store room. In the spreadsheet, I have the description, number of units on hand, number of units started with, part numbers, and a formula that is basically this... (original amount)-(amount on hand)/(box quantity for part)=Number of boxes to order.
In addition to this, I have conditional formatting for each part number. When the quantity gets to be 1/2 the original quantity, the entire line is highlighted in yellow. That the quantity drops below 1/2, it then goes to red.
Still with me so far? What I want to know is, would it be possible to have excel automatically generate an email with a particular subject line, and in the body state that part number xxxxxxx is at or below reorder level. x number of boxes need to be ordered ASAP.
Or something to that effect. Can this be done? If so, how? Keep in mind, that figuring out the conditional formatting was a stretch for my intelligence with Excel. I can send the spreadsheet to anyone that needs to see it in order to understand just what I am trying to explain.
Thanks in advance for any help.
I have a spreadsheet that shows the inventory I have in my store room. In the spreadsheet, I have the description, number of units on hand, number of units started with, part numbers, and a formula that is basically this... (original amount)-(amount on hand)/(box quantity for part)=Number of boxes to order.
In addition to this, I have conditional formatting for each part number. When the quantity gets to be 1/2 the original quantity, the entire line is highlighted in yellow. That the quantity drops below 1/2, it then goes to red.
Still with me so far? What I want to know is, would it be possible to have excel automatically generate an email with a particular subject line, and in the body state that part number xxxxxxx is at or below reorder level. x number of boxes need to be ordered ASAP.
Or something to that effect. Can this be done? If so, how? Keep in mind, that figuring out the conditional formatting was a stretch for my intelligence with Excel. I can send the spreadsheet to anyone that needs to see it in order to understand just what I am trying to explain.
Thanks in advance for any help.