Thursday, July 24, 2025

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

Previous article
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

GoDaddy Defederation

After putting the YouTube video together for this topic I decided to add those commands that you would need in the video into an...

Microsoft 365 Discovery Report

Overview The Microsoft 365 Discovery Report is a collection of outputs from the various workloads inside a Microsoft 365 tenant, all consolidated into a single...

Google GSuite Discovery Tool

When it comes time to perform a migration from Google GSuite to Microsoft 365 the first thing we always ask is - "How much...

Stay Connected

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

Latest Articles