Excel Mail Merge To Email

💻 About

A tool to allow you to create mail merge emails from an Excel table on OneDrive. e.g. put a name in the body of each email.

ℹ️ How To Use It

Go Here To Try It and Follow The Instructions

🗂️ Tech:

I wanted to demonstrate what can be done with Blazor WASM and some of the great tools available for it. The project outside of the API calls is a static site (no backend).

• MudBlazor component libary has been used for the UI which is great for blazor development
• CKEditor as the HTML body editor. This is wrapped in a component that handles the JS Interop back and forth
• The OneDrive file picker has been used. This is also wrapped in a component to handle the JS Interop
• Graph has been used to select and process an excel table
• Graph has been used to send emails in bulk mail merged with the excel data

📥 Installation & Set Up

Clone the repo and create an App Registration in Azure Active Directory. It will need the permissions User.Read,Mail.Send,Files.Read,Files.Read.All,Sites.Read.All. It will also need Access Tokens/ID Tokens selecting alogn with a relevant rspa redirect url.

Set your Client ID in appsettings.Json

---

TODO

I ran out of time as I only saw this 2 days before the hackathon closed

• Improve the documentation here and instructions on the site
• Look into batching the emails to save on graph calls and throttling
• Expose exceptions where the selected Excel data isn't valid to the user or sending fails
• General UI improvements such as progress of sending the emails
• Change body text field to a HTML editor such as TinyMCE I have wrapped CKEditor