Exporting a result list onto an HTML email alert

Question

I am trying to export the result of a powershell script. The idea is to export the result via email on Azure. The code snippet can be found below.

Get-AzSqlServer `
| %{ Get-AzSqlServerFirewallRule -ServerName $_.ServerName -ResourceGroupName $_.ResourceGroupName } `
| Select-Object -Property servername,FirewallRuleName

The idea here is to use automation runbook to run the snippet, not sure if there is a better way to run the snippet.