Having links from excel spreadsheet to my outlook tasks

S

soleil

What I have set up is an inventory supply sheet. What I would like to do is
when my supplies run low, I would like an alarm from outlook to pop up
letting me know that I need to order that item. Is this possible?

Thanks!
Soleil
 
M

mrice

Yes it should be.

I would suggest a macro linked to the worksheet_change event on a
workbook which references the Outlook object library.

This would run every time a change to stock was made and this could
detect if any of your items have fallen below your trigger level.
 
Top