Peter has attended:
Excel Advanced course
Excel / outlook
how do i combine excel dater with outlook tasks?
RE: excel / outlook
Hi Peter,
You could Insert Excel file from Tasks in Outlook.
1) Open task in Outlook
2) Insert menu > file
3) select excel file
4) press ok
Katie
RE: excel / outlook
Hi thank you for the reply, i didnt really ask the question correctly, what i wanted to know was how to combine excel with outlook tasks so that if i enter a date into a excel spreadsheet i will get an alert via outlook tasks on that date, it would need to be an on going spreadsheet and every date i enter will automaticly go into outlook tasks?. (that about covers it i think)
RE: excel / outlook
Sorry for this late reply Peter.
Excel cannot open Outlook task automatically. But there is an option in Excel to open Outlook task.
1) In Excel, open menu View > Toolbars > Reviewing
2) The 9th button, "ClipBoard with a red tick", will open Outlook Task window.
See if that's what you are after.
Katie
