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.--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=541712
- Mar 09 Fri 2007 20:36
Having links from excel spreadsheet to my outlook tasks
close
全站熱搜
留言列表
發表留言