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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date format in excel imported from an SQL DB. 2
Can Outlook alert me when dates in Excel spreadsheet become curren 4
Add date range 6
Windows Vista Macros to delete dates 0
Inserting an excel spreadsheet into a task in outlook 2007 7
Combining functions 2
Find then highlight in yellow 6
matching a column of numbers to another in another spreadsheet 1

Back
Top