Discussion Locked

Can outlook remind me of dates in excel

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a list of items in an excel worksheet which need calibration on different dates. Is there any way I can use outlook to get the dates from excel and notify me when they are due? I have Office 97 and outlook 98 installed.
If not can anyone think of anything else to try?

1 reply

by winlak

Name the range of data in the excel files that you want to transfer to outlook (minimally the item to calibrate and the date) including the column headings.
in outlook click file---import---other file type--task--excel--etc
map the date in excel to the due date in outlook.
This recreates the spreadsheet items as tasks in outlook.
if you like the results you do not have to use the excel file again as you can update in tasks.

This discussion is closed to new replies.