using excel to import calendar appointments

  • Thread starter Thread starter ********Meg
  • Start date Start date
M

********Meg

Does anyone know how to import recurring appointments from an excel sheet?

Office 2003
Windows XP

Thanks
 
Not sure if it's possible but try creating one in Outlook then exporting the
Calendar folder to an XLS file then take a look at it to see how Outlook
does it.
 
Sure, as long as you know how to write them. The easiest way to see how they
are written is to save an ics then open in notepad.

For most people, importing from excel then setting the recurring flag in
outlook is easier. :) Or just make single appointments in excel for each of
the dates. That is fairly simple using Excel formulas and features.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
Not sure if it's possible but try creating one in Outlook then exporting
the Calendar folder to an XLS file then take a look at it to see how
Outlook does it.
Click to expand...

You can't export recurring events. Outlook always makes you choose a range
of dates and then exports them as single items for the date range.
 
Thanks everyone. I actually created it in outlook, exported it and added it
to the rest of my appointments. This was the easiest solution.
 
********Meg said:
Thanks everyone. I actually created it in outlook, exported it
Click to expand...

Hmmm. next time do it the EASY way. If it's only a small number of
appointments, just attach them to an email and send it to yourself. Or, if
it's a large number then create a new pst file in Outlook, copy the
appointments to it, close it and do the reverse in the instance of Outlook
you want to transfer the appointments to....
 
Back
Top