search

microsoft / hack-together

Hack Together: Microsoft Graph and .NET is a hackathon for .NET developers to learn Microsoft Graph and Microsoft 365.
MIT License
523 stars 85 forks source link

Mail Merge Excel and Email #187

Open peterthorpe81 opened 1 year ago

peterthorpe81 commented 1 year ago

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 commented 1 year ago

This sounds like a nice experiment!

peterthorpe81 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 😊