Importing task description to outlook
 

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

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

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Mon, 28 Feb 2005 05:23:04 -0800, "P.hamsa"
wrote:

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