ms excel courses - excel outlook
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel courses - Excel / outlook

ms excel courses - Excel / outlook

resolvedResolved · Low Priority · Version Standard

replyReply Wed 12 Sep 2007, 15:30Delegate Peter said...

Peter has attended:
Excel Advanced course

Excel / outlook

how do i combine excel dater with outlook tasks?

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Sep 2007, 16:26Trainer Katie said...

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

replyReply Tue 25 Sep 2007, 20:06Delegate Peter said...

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)

replyReply Thu 4 Oct 2007, 16:48Trainer Katie said...

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

replyReply Fri 5 Oct 2007, 11:39Delegate Peter said...

RE: excel / outlook

Thank you Katie you have been a great help.

 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard