Import SEC dates and readings into Microsoft Outlook (2007-2008 version now ready)

Outlook calendar details
Now includes Daily Eucharist and Daily Prayer readings.

Current version: 1.0
Released Sunday 02 December 2007

Now updated for 2007-2008

Today is the First Sunday of Advent, which is the beginning of a new Church year.

So in preparation for this week I’ve been busy creating my annual CSV file that allows folks to import the dates for Saints’ days and Festivals of the Scottish Episcopal Church into Microsoft Outlook.

Versions

This year I’ve gone two steps further and created three files, instead of my usual (Standard) file:

  1. Standard
    Contains details of all saints’ days and festivals, but details of no readings (my usual file).
  2. Sunday readings
    Contains details of all saints’ days and festivals, and readings for only Sundays and Major Festivals.
  3. Complete
    Contains details of all saints’ days and festivals, and readings for all Sunday, Festival and Daily Eucharists, and Daily Prayer readings.

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

Download

Download your file of choice on the Saints and Festivals of the SEC in Microsoft Outlook page.

Report all errors

As always, if you spot an error please let me know so that I can fix the source file for other users. Thank you.

Saints’ Days and Festivals for Outlook 2006-2007

Outlook Calendar

At last! I’ve finally finished this year’s Guide to the Calendar and Lectionary of the Scottish Episcopal Church in a format that allows this information to be imported directly into Microsoft Office Outlook.

The calendar runs from the First Sunday of Advent which was … ahem! Sunday 3 December 2006. The hold up, however, was that I was unable to obtain an electronic copy before about a week ago; and the information isn’t on the SEC website.

You can download the file on my Saints’ Days in Outlook page, which also includes full instructions (with images) on how to import the data — it’s really simple.

Saints and Festivals of the Scottish Episcopal Church for MS Outlook

Screenshot of Outlook Calendar showing saints\' days
Screenshot of Outlook showing saints’ days and festivals imported into the Calendar.

Better late than never! I’ve finally got around to typing up the Scottish Episcopal Church saints’ days and festivals in a format that can easily be imported into the Microsoft Office Outlook Calendar.

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

Download

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

  • Saints’ Days and Festivals of the Scottish Episcopal Church Calendar, from Advent 2005 to The Last Sunday in Pentecost (Christ the King) 2006 (CSV, 23 KB)

Please note:

  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 and 2003.)
  2. Illustrations: All illustrations show Microsoft Office Outlook 2003; details may vary slightly for older copies of Outlook. 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, eg OpenOffice.org.
  4. Dates only: This file does not contain details of the readings for each day, only the name of the festival.
  5. Enjoy!

1. File > Import and Export …

Screenshot from Outlook 2003 of File, Import and Export

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

2. Import and Export Wizard

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)

Comma Separated Values (Windows) is selected=

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

4. Locate the CSV file to import

Import a File window

You will now be prompted to Import a File. Click the Browse … button and locate the file you downloaded called ChurchDates2006.csv, once selected click Next >.

5. Select Calendar under your Personal Folders

Select destination folder

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

Confirmation screen

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

Import and Export Progress bar

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

8. It’s done

Screenshot of Outlook Calendar showing saints\' days

Once complete, you’ll find that details of all the Scottish Episcopal Church saints’ days, festivals and Sundays, from Advent 2005 – The Last Sunday of Pentecost (Chrirst the King) 2006, have been added as all-day events to Outlook.

Calendar and Lectionary Guide 2005/2006

Calendar
A calendar, completely unlike the one used by the Church to work out which festival we should be celebrating this week.

Each year the Scottish Episcopal Church publishes a free guide to its calendar and lectionary. This guide helps to keep us clergy right throughout the year, as it lists each Sunday and major festival, with details such as its name (eg Week of 1 Advent), its category (1 through 6), its liturgical colour (eg Violet) and what Daily Prayer order should be used (eg DP Anticipation).

I’ve just finished formatting this booklet for the Web. For the first time, this document is now available for download in its entirety. It is available on the Liturgy page in HTML (webpage), A5 PDF booklet, and A4 PDF landscape formats.

Slowly but surely I’m getting through the various liturgy documents that need to go on the website. But it takes time. This one document took me about four hours.