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
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
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.
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks