Dr. Joachim Schlosser

Führung | Effektivität | Fotografie

  • Über
    • Bio und Pressefotos
    • Bio and Photos (English)
  • Werkzeuge
    • Sketchnotes
  • Speaking
  • Kontakt
    • Produkte

Vacation Time ‒ Quickly Delete Multiple Appointments in Outlook

It is vacation time. You are looking forward to some days off , and therefore want to cancel appointments in Outlook that either you scheduled or accepted.

This takes time even if you are quick with keyboards, because for each appointment you need some mouse clicks and to enter the cancellation message.

Remedy is brought by a VBA script, taking over this annoying task.

Since for each week there are a dozen meetings or more, this script will save me tons of time and effort and errors.

This post is available in German, too: Urlaubszeit ‒ viele Termine in Outlook schneller absagen

Steps for cancelling Outlook appointments

Outlook Manual Deletion of Appointments

The following steps you manually do for each appointment:

  1. In your calendar you select all meetings that you want to cancel, regardless whether you are the one who has invited, or are just participant.
  2. Then you start removal by pressing the delete key, triggering a whirl of windows.
  3. For all own appointments Outlook opens the calendar item. Here you enter a message for cancelling and click “Send”. For each meeting this makes at least three clicks and four key strokes. If you are good.
  4. For all accepted appointments Outlook asks if you want to cancel with a message to the organizer. Being nice to your colleagues you click yes and fill the message window. For each meeting at least four clicks and four key strokes. If you are good.

Easier with Automation

Outlook Automatic Deletion of Appointments

Most often you want to send the same cancel message to all and just cancel this recurring item, not the whole series.

That means there is nothing to decide for each appointment, and nothing to re-phrase, but you still need to click fresh and copy & paste.

For this, computer science gave us scripting languages. In my concrete case my Visual Basic script is called BulkDeleteAppointments.bas. This takes on the task for you.

  • In Outlook you select either a date range in the calendar view or multiple calendar items.
  • You have just internal meetings in the date range of question that should all receive the same message? Then select the date range.
  • You want to cancel multiple meetings with the same message, but retain others? Then select multiple calendar items using the Ctrl- or Shift-key.
  • With Alt-F8 you open the Macro dialog and choose the macro BulkDeleteAppointments. It asks you for the message to send, then creates the cancellation notes and deletes the appointments. Finished.

Be careful, because the script does not ask for confirmation.

If you do not trust the script or me, then first set Outlook into offline mode and only then execute BulkDeleteAppointments. Sometimes the script does throw an error, which seems to be caused by some unhandled appointment properties. In this case simply re-start the script on the remaining appointments.

Setup

In order to use the script you need to integrate it into Outlook. To do that you import it into the macro editor and digitally sign it for Outlook to feel safe.

  1. Download BulkDeleteAppointments.bas.
  2. In Outlook open the Macro editor with keys Alt-F11.
  3. In menu File select Import File.
  4. Select the downloaded script BulkDeleteAppointments.bas.
  5. MS Office Selfcert
    MS Office Selfcert

    Create a new digital signature by running C:\Program Files\Microsoft Office\root\Office16\selfcert.EXE. Instead of Office16 the folder could have a different name in your system. Enter a name for your certificate and confirm.

  6. Sign in the macro editor by clicking menu Tools, Digital Signature… and there select your newly created certificate.

Done.

What do you automate?

This script you can see on Github as well as modify.

So what else do you automate in Outlook?

If you like the script, or if you have further concrete ideas, then please comment and sign up for my free newsletter. With this, you never miss out on news about my productivity tips. If there is enough interest I may create an Outlook Add-In from the script, making it easier to install.

Photo: Joachim Schlosser, License Creative Commons Attribution Share-Alike

Teilen & Verweilen

Ähnliche Beiträge:

  • Corona crisis as accelerator of digitization: 8+1 ways
  • Onboarding newbies in the information economy
  • Every time you use PowerPoint for documenting, a kitten dies. 7 Steps to better documentation
  • Onboarding as newbie or recent graduate in a company

Filed Under: Effectivity

27. August 2014 von Joachim Schlosser 8 Comments

E-Mail effizient einsetzen

Kostenloses eBook

Das eBook »E-Mail effizient einsetzen« zeigt Ihnen, wie Sie E-Mail besser nutzen. Mehr Info...

Ja, will ich haben!

Über 1800 E-Mail-Abonnenten!
« The Beauty of Performance Review Conversation – 5 Lists of 5 Whys and Tips
Always Be Curious – A Mindset for Better Conversations »

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • DeutschDeutsch

RSS-Feed English RSS Feed

Ähnliche Beiträge:

  • Corona crisis as accelerator of digitization: 8+1 ways
  • Onboarding newbies in the information economy
  • Every time you use PowerPoint for documenting, a kitten dies. 7 Steps to better documentation
  • Onboarding as newbie or recent graduate in a company

Meistgelesen

  • Every time you use PowerPoint for documenting, a kitten dies. 7 Steps to better documentation
  • Onboarding as newbie or recent graduate in a company
  • Corona crisis as accelerator of digitization: 8+1 ways
  • Onboarding newbies in the information economy
  • Every time you version by filename, a kitten dies – Implicit Versions in Confluence, OneDrive, SharePoint, Dropbox
  • Reading on Patterns of Success: Ray Dalio – Principles
  • Delay emails in Outlook for 3 minutes and never be annoyed again about premature sending

Wer schreibt hier?

Hallo. Ich bin Dr. Joachim Schlosser. Beruflich führe ich bei Elektrobit Automotive Informatiker und Ingenieure, die Automobilfirmen zu Softwarearchitektur, Agile Entwicklung und Funktionale Sicherheit beraten. Daneben bin ich Autor eines LaTeX-Lehrbuches, MINT-Botschafter und blogge zweiwöchentlich hier auf www.schlosser.info.

Ich bin glücklich verheiratet, Vater dreier Kinder, Fotograf, bekennender Produktivitäts-Junkie und Getting-Things-Done Anhänger sowie Vortragscoach für meine Mitarbeiter und Kollegen. Über diese Themen schreibe ich auch hier.

Copyright 2000–∞ Dr. Joachim Schlosser. Impressum. Datenschutzerklärung.

Manage Cookie Consent
Wir verwenden Cookies, um unsere Website und unseren Service zu optimieren.
Funktional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
Vorlieben
{title} {title} {title}

[emailsignup_uni source=popup bare=-1]