Publish part of Outlook agenda on Google

[F.H. van Zelm]

Hi,

(One newbe can ask more than 1,000 wise guys can answer. This
will be an example. Although: you all know a lot.)

I want to publish a part of my Outlook agenda in the Google agenda.
'Part of' means:
- only working days
- between, say 08:30 and 18:00, so working hours
- perhaps some specially marked appointments

What I can think of:
- GSyncIt to do the job.
- But does GSyncIt allow the time slot? (I just found the program.)
- Or create a second Outlook agenda, filled with the appropriate
appointments, using VBA and then use GSyncIt.
- Anything else ...

Kind regards, Frans

 

[Guest]

Found it. You can import csv or Ical files in google calendar. directions
are at :
http://www.google.com/support/calendar/bin/answer.py?answer=37118&topic=8566

You can export your calendar from Outlook 2007 in either format, or in
previous OL versions as CSV.

To get only the appointments you want may be tricky. You could create a
temporary calendar and drag/drop the items you want from your default
calendar to the temp and export that calendar. That's probably the easiest
way.

CSV and iCal files are both text based files. You could open either with
notepad, and the syntax should be obvious enough in each to delete the stuff
you do not want. Excel can also open the CSV file and you can delete the
rows of appts from it you do not want to delete.

Hope some of this helps,

 

[F.H. van Zelm]

Thanks for reply. I'll give it a try. Though that 'time slot' thing is
important to
me. I woudn't like to manually copy or delete tens of appointmets every
week.

Frans