SEC Outlook

Current version: 2009-2010 (UPDATED)

Updated: Sunday 06 December 2009

Corrections

The following errors have now been corrected:

• 29 December 2009
  John, Apostle and Evangelist [4] White (translated from 29 December) should read: John, Apostle and Evangelist [4] White (translated from 27 December)

The following files allow you to import the Scottish Episcopal Church saints’ days and festivals for 2008-2009 into the Microsoft Office Outlook Calendar.

These files contain saints’ days and festivals from the First Sunday of Advent 2009 to the week of The Last Sunday after Pentecost (Christ the King) 2010, inclusive, as well as the readings for each day (Eucharist and Daily Prayer).

Please feel free to download this file and follow the simple, illustrated instructions on how to import it into Microsoft Office Outlook.

Download

To download these files, right-click the link in your browser and select Save Link As….

Import into Microsoft Outlook

• Standard (CSV, 25 KB)
  Contains details of all saints’ days and festivals, but no details of readings.

• Sunday readings (CSV, 44 KB)
  Contains details of all saints’ days and festivals, and readings for Sundays and major festivals only.

• COMING SOON: Complete
  Contains details of all saints’ days and festivals, and readings for all Sunday, Festival and Daily Eucharists, and Daily Prayer readings.

iCalendar

This year I’ve also created an iCalendar feed of each version which you are welcome to import into Microsoft Outlook, Google Calendar, Apple iCal, etc.

• Standard (ICS, 122 KB)
  Contains details of all saints’ days and festivals, but details of no readings (my usual file).

• Sunday readings (ICS, 144 KB)
  Contains details of all saints’ days and festivals, and readings for Sundays and major festivals only.

Important notes

1. Back-up
   Make sure you back-up your Outlook .PST file before you import. (I recommend that you use the Personal Folders Backup application which works for Outlook 2000, Outlook 2002 XP, 2003 and 2007.)

2. Illustrations
   All illustrations show Microsoft Office Outlook 2003; details may vary slightly for older (or newer) copies of Outlook; I have tested this in Outlook 2007 successfully. This does not work for Microsoft Outlook Express, which is an email application and does not offer calendar functions.

3. Accuracy
   Details are as far as possible correct, although a few errors may have crept in in the production of this file (for example in how translated (moved) minor festivals have been scheduled). It was produced for my own personal use, but I’ve also decided to release it into the public domain. Feel free to use and/or adapt it to your own use. The file can be edited in Microsoft Office Excel (or other spreadsheet, e.g. OpenOffice.org.

4. Readings
   In the “Complete” version, the readings for ordinary saints days and lesser festivals are simply those for that day of the week in relation to the previous Sunday rather specifically for that minor saint/festival. For example, the readings given for Ambrose of Milan (Friday 07 December) are those for the Friday of Advent 1.

   In other words, I’ve used only readings from The Lectionary and the Readings for Festivals, and not those from elsewhere or from the Readings for Special Occasions or Common Readings for Saints Days.

Step-by-step installation guide

1. File > Import and Export …

Open Microsoft Outlook, and from the File menu select Import and Export…

2. Import and Export Wizard

The Import and Export Wizard window will open. Select Import from another program or file, then click Next >.

3. Select Comma Separated Values (Windows)

Select Comma Separated Values (Windows) from the list, and click Next >.

4. Locate the CSV file to import

You will now be prompted to Import a File. Click the Browse … button and locate the file you downloaded, e.g.

sec_dates_2007-2008_readings.csv

once selected click Next >.

5. Select Calendar under your Personal Folders

Now select the destination folder from those listed under your Outlook Personal Folders. You want to select Calendar, and then click Next >.

6. Confirm and click Finish

You will be presented with a confirmation screen, similar to the one above. Make sure that the details are correct — and if you need to, check that the Map Custom Fields… settings are correct (by default, they should be). Click Finish to begin importing the details into your Outlook Calendar.

7. Import is in progress

Outlook will begin to import the information into your Outlook Calendar, showing you its progress (as above).

8. It’s done

Once complete, you’ll find that details of all the Scottish Episcopal Church saints’ days, festivals and Sundays, from Advent 2007 to the Saturday after the Last Sunday of Pentecost (Christ the King) 2008, have been added as all-day events to Outlook.

---

Archive

(Right-click and select Save Link As….)

2008-2009

• Standard (CSV, 25 KB)
  Contains details of all saints’ days and festivals, but details of no readings.

• Sunday readings (CSV, 40 KB)
  Contains details of all saints’ days and festivals, and readings for only Sundays and major festivals.

• Complete (CSV, 93 KB)
  Contains details of all saints’ days and festivals, and readings for all Sunday, Festival and Daily Eucharists, and Daily Prayer readings.

2007-2008

• Sunday readings (CSV, 70 KB)
  Contains details of all saints’ days and festivals, and readings for only Sundays and major festivals.
• Complete (CSV, 107 KB)
  Contains details of all saints’ days and festivals, and readings for all Sunday, festival and daily eucharists, and daily prayer readings.

2006-2007

• Standard (CSV, 23 KB)
  Contains details of all saints’ days and festivals, but no details of readings.

2005-2006

• Standard (CSV, 22 KB)
  Contains details of all saints’ days and festivals, but no details of readings.

---

Comments

If you’d like to leave a comment, please do so on the blog post: Import SEC dates and readings into Microsoft Outlook (2007-2008 version now ready).