4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
Read Time:1 Min, 29 Sec
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day. Yep, I said “thousands”. I work for a very successful Managed Services provider and we have many clients. In order to ensure the highest level of service we are sent all alerts/notifications/etc. as to the health of our client’s systems. Then, each team member sets up Outlook Rules to narrow the scope of the emails we see to only those clients with which we are directly involved. This method isn’t perfect, but it does cut down on the amount of distribution list management.
With that many emails coming in, you can imagine that I had 50+ Outlook Rules configured. Unfortunately, with that man Outlook Rules there would be times that I would miss messages because they got caught in an Outlook Rule that didn’t intend for it to get caught in.
To get more control over the filing of my incoming emails, I decided I needed to consolidate my Outlook Rules. However, I first needed to get a better idea of what I already had out there. That’s when I put together this simple PowerShell script to export all my Outlook Rules to a .csv file.
set-executionpolicy bypass Import-Module ExchangeOnlineManagement Connect-ExchangeOnline Get-InboxRule | Export-Csv -NoTypeInformation "$HOME\Downloads\rules.csv"
Using the code above, I was able to export my Outlook Rules to a .csv file. From there, I found rules with common criteria and combined them. I was also able to find other Outlook Rules that no longer applied and deleted those. In the end, I was able to reduce my 50+ Outlook Rules to only 17 Outlook Rules.
Now, that is a much more manageable number or Outlook Rules.
Average Rating