Triggering an Outlook alert from a date on an Excel Spreadsheet

[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".

 

[Roady [MVP]]

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.