Importing task description to outlook

[Guest]

Hi,
I have an excel sheet,where there is a description of activities and target
dates to complete those.
I want to import this to outlook as "Tasks".
Can you please let me know how to do this?

Thanks in advance

 

[Gord Dibben]

First have the task descriptions and due dates an Excel sheet in two columns
with a title for each in Row 1.

File>Save As>File Type CSV(comma delimited)(*.csv)

Click "Yes" when you get the messages about losing formats and "are you sure"?

Close the file.

Now open Outlook and File>Import/Export>Import from another file>Comma
Separated Values(Windows)>Next>File to Import(you can browse to your saved
*.csv file). Next you will be asked where to import them to.

You would select "Tasks".

Follow the instructions to "Map Fields" you will get a Map. Drag your "From"
descriptions title to the appropriate "To" place on the map. I would suggest
"Subject".

Drag your "Due date" to "Due date".

Continue with the OK's until Outlook pulls all from the *.csv file(should take
only a few seconds).


Gord Dibben Excel MVP