Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
markmidwest
 
Posts: n/a
Default 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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
kza40381
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Peachtree export to excel Aviso Setting up and Configuration of Excel 0 March 4th 05 01:04 AM
Outlook 2003 calendar events into Excel 2003? Kolin Tregaskes Excel Discussion (Misc queries) 4 January 31st 05 07:30 AM
How do I link to an Outlook public folder from an Excel spreadshe. DJBaker Excel Discussion (Misc queries) 0 January 28th 05 07:35 PM
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 02:41 AM
Excel and OUTLOOK Andre Croteau Excel Discussion (Misc queries) 1 November 28th 04 08:33 PM


All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"