Wouldn’t it be nice to have a handy list of appointments that you have scheduled for recurring events? One might think that would be available in MS Outlook but alas, it is not. There is, however, a way to get around MS Outlook’s limitation and print out a list of those recurring appointments.
You can export your calendar to MS Excel! Once you have done that, you can then sort and filter the list and then print it.
Follow the steps below to learn how:
To export your calendar to Excel:
- In Outlook, click on File | Import And Export.
- Select Export To A File from the Choose An Action To Perform list.
- Click Next.
- Select Microsoft Excel 97 – 2003 from the Create A File Of Type list.
- Click Next.
- Click Calendar in the Select Folder To Export From list.
- Click Next.
- Click Browse and navigate to the folder where you would like to save the workbook.
- Name your workbook.
- Click OK.
- Click Finish.
Specify the appropriate date range for your export.
Once MS Outlook completes the export, ope the workbook and click the Calendar tab.
If there is no tab visible named Calendar, you may have to click around some to find your Calendar items.
You can use a filter to exclude all but the recurring items and then sort the filtered results to arrange them as necessary.
You can now print your filtered list!