Having links from excel spreadsheet to my outlook tasks
 

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

Having links from excel spreadsheet to my outlook tasks
 

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: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=541712