Triggering an Outlook alert from a date on an Excel Spreadsheet

  • Thread starter Thread starter vlpckett
  • Start date Start date
V

vlpckett

I have Outlook and Excel 2003. I have a purchasing schedule on an Excel
spreadsheet and I would like Outlook to give me a notification when the date
on the spreadsheet comes up. I have the Excel spreadsheet set up to
continually recalculate the next purchase date for each item (column B).

Excel spreadsheet:
A B
1 Paint 10/15/09
2 Brushes 11/02/09
3 Canvas 11/28/09

For example, on 10/15/09, say at 8:00am, I would like Outlook to trigger a
notification to "Buy Paint".
 
You'll have to somehow put this data into Outlook then. You can do that
either via VBA from within Excel, or you can restructure your Excel sheet in
such a way that it allows itself to be imported by Outlook as a Calendar or
Task item.
 
Back
Top