Is there any way to 'bulk' enter the calender entry into the PPC...

I would like to keep trace of cricket fixtures etc, which I have in excel, and want all of them to come to my calender... any idea??

I can re-format them, if it needs to be stored in particular format (csv/tsv or any other)

SKP

quote:

Is there any way to 'bulk' enter the calender entry into the PPC...

I'll have a look in to this I seem to recall a macro writen in Excel to import data to outlook.
rgds
Steve

Skp

If you export a sample of your calander entries to an excel file you will get a series of 22 columns.

Subject/StartDate/StartTime/EndDate/EndTime/Alldayevent/
Reminderonoff/ReminderDate/ReminderTime/MeetingOrganizer
/RequiredAttendees/OptionalAttendees/MeetingResources/
BillingInformation/Categories/Description/Location/Mileage
/Priority/Private/Sensitivity/Showtimeas

From these columns it should be obvious what to populate them with using your own example many fields wont be required and the format should similary be replicated

You should then be able to re-import to outlook then synch

rgds
Steve

quote:

Originally posted by SteveJ:
From these columns it should be obvious what to populate them with using your own example many fields wont be required and the format should similary be replicated

You should then be able to re-import to outlook then synch

Thanks for the reply!!!

Guess what... thats the FIRST thing I tried and an IMPORT. It didnt work. I have Office 2002 at home, and didnt work.

I will try the similar approach tomorrow at office PC - 2003 version. lets see...

SKP

quote:

I will try the similar approach tomorrow at office PC - 2003 version. lets see...

Opps I have 2003 will try one myself also try export excel as csv and import
rgds
Steve

yes.. i created my entries and savwed them in CSV ofrmat only...

I checked with other online help... I guess I should save the file in iCalendar format orsomething else.... all tomorrow

SKP
No problem in 2003 edited excel file then re-imported excel file

rgds
Steve

2003... worked like charm... I didnt take the actual file... will do it tom..

Thanks

Skp

quote:

2003... worked like charm... I didnt take the actual file... will do it tom.. Thanks

No props M8 must of been the easyest one yet for us not sure on repeatability setting though
rgds
Steve