Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel database into Outlook Contacts says "No Named Rang | Excel Discussion (Misc queries) | |||
importing xcel into outlook | Excel Discussion (Misc queries) | |||
Translaton Error when importing Excel data into Outlook? | Excel Discussion (Misc queries) | |||
linking an excel document to my task folder in outlook | Excel Discussion (Misc queries) | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) |