Sanitized Outlook Event Forwarding
This is an example of what I use with my work calendar, when I need to forward something to my personal calendar.
This macro does not include any of the meeting content (who will be there, what the content is), but is just to block out the time
to prevent your personal and professional lives from overlapping. This macro will create a new appointment for the time window,
optionally including the subject (or replace it with
[WORK]) and optionally including the location (or replace it with
After the invite has been sent, it deletes the invite, so it doesn't look like you've got two meetings at the same time.
It's also worth noting that you could potentially use the same code example to create a "travelling time" event before and after an appointment, if you're a person who travels to events (rather than telecommuting, you filthy animal ;) ) but I'll leave that as an exercise for the reader :)
Adding this in!
Alt+F11in MS Outlook to open the VBA Editor, and paste the content of the other file in. Replace "
email@example.com" with your email address. Note: You are likely to get a notification that Macros are disabled. You will need to OK this each time it comes up (probably each time you trigger the macro for the first time).
- Open an outlook meeting or appointment. Right click on the ribbon, and select "Customize the ribbon...". Click on "Respond" on the "Main Tabs" block on the right, then click on "New group" and name it "Personal" (or choose your own ;) ). In the "Choose commands from" drop-down, select Macros, and then select the only macro in the box underneath. Click on the "Add >>" button in the middle. Click on "OK".