I am looking for some help with a technical issue I have. In my current workplace we have an automatic scheduling system that handles our appointments. When an appointment is booked (through a web based method we have no control over), we are sent an automatic email (all from the same address) with an ICS meeting attachment. We then have to open this attachment for it to appear in our calendars.
The problem - it is extremely time consuming and unreliable, as some people delete the email and pretend they never received it to avoid work! Setting Outlook to automatically accept meetings doesn't work, as they are ICS attachments rather than direct invites.
What I need (ideally) is a way to automatically accept the ICS meeting attachment when the email is received, without any user interface. This should then show up on our calendars automatically.
I have some experience in VBA, but this is extremely minimal and is confined to pasting other peoples solutions in there! So any help on this front would be amazing.
In case you need to know, we use Microsoft Office 2010, so the calendar and emails are all through Outlook 2010.