Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Export excel dates into outlook calendar


  • Please log in to reply

#1
james_lovett

james_lovett

    New Member

  • Member
  • Pip
  • 1 posts
Hi there,

I am new here and any help will be very much appreciated.

I have an excel spreadsheet with a project schedule running down a column. I would like to click a button and export this list of dates into a graphical calendar which I could print out showing me what I am doing and when.

The calendar could just say project fieldwork start and fill in a key attached with the schedule.

Can anyone help or point me in the right direction?

Cheers
James
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
James,
If you have MS Outlook installed you can try the following;
Tested with Outlook 2003


Step1 - Create a Template

From Outlook select the following menu items
> File
> Import and Export
> Export to a File > Next
> Comma Seperated Values > Next
> Calendar > Next
> Enter DestinationFileName.csv > Next
> Export Appointments > Finish
> Enter Date Range > OK

N.B. Make sure you have some example appointments created before you start


Step2 - Format Data to Import

> Open DestinationFileName.csv
> Add your data to the correct columns
> Save your csv file


Step3 - Import your data

From Outlook select the following menu items
> File
> Import and Export
> Import from another program or File > Next
> Comma Seperated Values > Next
> Enter SourceFileName.csv > Next
> Calendar > Next
> Import SourceFileName.csv into folder : Calendar > Finish


Step4 - View / Print data



hth

dsm
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP