Here's the deal. For work I need to send out multiple calendar invites at a time (sometimes 30 different meetings in a week). The invitations contain mostly the same information (subject line, location, body of the email), but sometimes they vary a little (for example, attendees & invitation time slots might be different).
Sometimes I have to update all of the invitations after I've already sent them. This is a manual process and is very time consuming.
Is there a way to make this process easier? Can I create an Excel doc that contains the list of attendees, subject line, body of the invite, start time, end time and then create the invites based on that list? Basically I'm thinking something like Mail Merge, but for Outlook invites.
I'd be willing to do some minor Outlook coding (VBAs or macros?) if the directions are extremely clear (I am not a coder). Thanks!