A reader of my site asked me if there is a way to receive an overview of a calendar by e-mail. The background was that a vacation calendar was maintained within the department, which was an Exchange resource mailbox in which each team member entered their vacation. The requirement was to receive an overview of this calendar for the next 4 weeks by e-mail.
For this small requirement I have created a PowerShell script that uses the Exchange EWS API and reads the calendar and sends the entries as a table in a mail. This is what a mail looks like:
The script is now simply started every Monday morning via a scheduled task and then sends the mail. If someone has similar requirements, the script can be adapted accordingly. The download link can be found at the end of the article.
The EWS API 2.2 is required, which can be downloaded here:
The script can be downloaded here:
The script still needs to be adapted to your own environment, but I think this is self-explanatory. As a rule, it will probably be sufficient to adapt the first 9 lines in the script. If a longer period is required (default 28 days), this can be adjusted in line 38. A maximum of 200 entries are listed in the overview (line 40).
The script can then be started at a selected time via task scheduling:
Questions or suggestions for improvement are welcome by e-mail.