Automate to send bulk Calendar invites through Outlook

Nagarjuna Vijayagiri 6 Reputation points
2021-03-04T11:50:13.567+00:00

Hi There,

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!

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,294 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,401 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
4,813 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jade Liang-MSFT 9,946 Reputation points Microsoft Employee
    2021-03-05T02:28:40.293+00:00

    Hi @Nagarjuna Vijayagiri ,

    For your requirement, as I know, there may be no option in Outlook client that could meet it directly. But if you just would like to send multiple calendar invitations faster or easier, as a suggestion, we could try to save a template (or some templates) with some general attendees or description, so that we could open your local template and modify it directly when we need to send an invitation. Here are the detailed steps : creat a template : New meeting> type your general information>File>Save as>choose .oft, use the template : New item>More item>choose form>User Templates in File System>choose your form.

    If you still need more information about macro, due to I mainly focus on general issue on Outlook desktop client, I know little about macro and scripts. But based on my research, I found a related article: Create Appointments Using Spreadsheet Data , which mentioned some excel macros, please kindly check if it could also be helpful to you. (Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

    If your issue has any update, please feel free to post back.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.