Mail Merge Excel and Email

[peterthorpe81]

Project name

Mail Merge

Description

A tool to access an Excel table on OneDrive read the content and use it to mail merge an Email e.g. forename in body. The email can then be sent via Graph.

This is just 2 days of playing with graph as I wasn't aware of the event until recently.

Repo URL

https://github.com/peterthorpe81/MailMergePublic

Team members

peterthorpe81

[svrooij]

This sounds like a nice experiment!

[peterthorpe81]

This sounds like a nice experiment!

I probably need to implement your batching system, which looks great. Im just using a sempahore slim at the moment which seemed to work at 4 requests at a time on an old project. This project seems to get stuck past 1 but it may be my test data having the same email twice.

[svrooij]

Not my batching system 😇
I just made it a little bit better. Here is the background story, https://svrooij.io/2023/03/03/batching-in-microsoft-graph/

And even though doing cloud mail merge is really cool, you're going to hit outbound mail limits pretty quickly. Maybe you can extend to supporting a mail provider like sendgrid.

I would never came up with the idea, (excel in OneDrive as source for mail merge), that triggered my interest.

May the best submission win!

[waldekmastykarz]

Very nice @peterthorpe81! Would you be willing to record a short video to demonstrate the app? It's not required for the hackathon but it would help us showcase your work internally at Microsoft and publicly in the community 😊