Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Export Excel Dates to Outlook Calendar?
I have a spreadsheet with 2 columns; 1 is a date & the other is work that
needs to be done on that date. Is there a way to export this spreadsheet into either an Outlook calendar or task so on the specified dates I will be reminded of the work that needs to be done? Thanks in advance, Mark |
#2
|
|||
|
|||
Mark
Save the Excel workbook as a *.CSV file. Go into Outlook and FileImport/Export. Import from another program or file. You will select Comma Separated Values(Windows) Following your nose from there you will be able to map the dates and reminders to Tasks or Calendar. Gord Dibben Excel MVP On Fri, 25 Mar 2005 09:27:04 -0800, "markmidwest" wrote: I have a spreadsheet with 2 columns; 1 is a date & the other is work that needs to be done on that date. Is there a way to export this spreadsheet into either an Outlook calendar or task so on the specified dates I will be reminded of the work that needs to be done? Thanks in advance, Mark |
#3
|
|||
|
|||
Gord, is it possible to export or link an excel spreadsheet which contains
start and finish dates of scheduled courses to an excel calendar template or another program so we could have an electronic calendar? I can import into MSProject, but licensing too expensive. "Gord Dibben" wrote: Mark Save the Excel workbook as a *.CSV file. Go into Outlook and FileImport/Export. Import from another program or file. You will select Comma Separated Values(Windows) Following your nose from there you will be able to map the dates and reminders to Tasks or Calendar. Gord Dibben Excel MVP On Fri, 25 Mar 2005 09:27:04 -0800, "markmidwest" wrote: I have a spreadsheet with 2 columns; 1 is a date & the other is work that needs to be done on that date. Is there a way to export this spreadsheet into either an Outlook calendar or task so on the specified dates I will be reminded of the work that needs to be done? Thanks in advance, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Peachtree export to excel | Setting up and Configuration of Excel | |||
Outlook 2003 calendar events into Excel 2003? | Excel Discussion (Misc queries) | |||
How do I link to an Outlook public folder from an Excel spreadshe. | Excel Discussion (Misc queries) | |||
Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
Excel and OUTLOOK | Excel Discussion (Misc queries) |