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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

View past appointments in Outlook 2007 calendar 2
Outlook 2007 Recurring Appointment Problem 1
Active Appointments View - Recurring Appointments 1
Why aren't all day events visible in shared calendars? 1
Outlook 2003 sp3 dates import from palm desktop 2
importing appointments 3
reminders for outlook calendar 2
New Calendar won't print time or complete event 1

Back
Top