Saturday, July 4, 2026

Creating User Accounts and Send Personalized Emails with PowerShell and MsGraph

Soooooo.. HR gave you a spreadsheet with 500 names on it and have requested that you provision all the new accounts in Microsoft 365. They have given you a welcome pack PDF file and want personalized emails to go out to everybody letting them know the new UPN and Password!

Well before you go and cry in the corner, let me save you from that. Here is a set of files that is going to automate that so damn well you can go take the rest of the day off. You’re welcome!

The entire process is in this video.

What you will need though is the files that I reference in the video. Important to grab those. The best place to run them is from your local machine so drop them in the C:\SCRIPTS directory and you are good to go.

The whole process works by creating an application registration, then uploaded a self-signed certificate there. Then updating the script with the app/client ID references, and you are good to go. Don’t worry, it’s all explained in the video.

Here are the files.

If you have any thing you want to chat about then please drop me an email to mark@thecloudgeezer.com and I am always happy to do that.

Have a good week wherever you are.

Mark – The Cloud Geezer

Mark Rochester
Mark Rochesterhttps://thecloudgeezer.com
Mark currently works in the cloud space assisting large companies to migrate from either on premises to the cloud, or cloud to cloud. His experience with Enterprise migrations spans more than 25 years which basically makes him old. However, with all the oldness creeping up he still finds technology massively exciting. Please reach out for a chat anytime you would like. :-)

Related Articles

OneDrive Sharing Report – June 2026

Take Control of OneDrive Sharing Across Your Entire Microsoft 365 Tenant Let's be honest — Microsoft's built-in sharing reports are pretty underwhelming. They show you...

SharePoint Discovery Tool

Know exactly who has access to what across your entire SharePoint Online environment. Managing SharePoint permissions at scale is one of the most time-consuming and...

Microsoft 365 Discovery Report

How long does a full Microsoft 365 tenant assessment take you? For me, it used to be half a day. Clicking through Exchange admin, SharePoint...

Stay Connected

88FansLike
36,999FollowersFollow
70,704SubscribersSubscribe
- Advertisement -

Latest Articles