MailReport.ps1
|
# --- Default inline image assets --------------------------------------------- # Load the default header/footer PNGs once per module import. Reading from disk # every Send-RjReportEmail call would waste IO when a runbook sends several # reports. $PSScriptRoot resolves to the module root because this file is # dot-sourced from RealmJoin.RunbookHelper.psm1. $script:RjRbDefaultHeaderPath = Join-Path $PSScriptRoot 'Assets\Header.png' $script:RjRbDefaultFooterPath = Join-Path $PSScriptRoot 'Assets\Footer.png' if (Test-Path -LiteralPath $script:RjRbDefaultHeaderPath -PathType Leaf) { try { $script:RjRbDefaultHeaderBytes = [IO.File]::ReadAllBytes($script:RjRbDefaultHeaderPath) } catch { Write-Warning "RealmJoin.RunbookHelper: Could not read default header image '$script:RjRbDefaultHeaderPath': $($_.Exception.Message)" $script:RjRbDefaultHeaderBytes = $null } } else { $script:RjRbDefaultHeaderBytes = $null } if (Test-Path -LiteralPath $script:RjRbDefaultFooterPath -PathType Leaf) { try { $script:RjRbDefaultFooterBytes = [IO.File]::ReadAllBytes($script:RjRbDefaultFooterPath) } catch { Write-Warning "RealmJoin.RunbookHelper: Could not read default footer image '$script:RjRbDefaultFooterPath': $($_.Exception.Message)" $script:RjRbDefaultFooterBytes = $null } } else { $script:RjRbDefaultFooterBytes = $null } function Write-RjRbForcedWarning { <# .SYNOPSIS Emits a Write-Warning that bypasses any caller-side $WarningPreference override. .DESCRIPTION Write-Warning is suppressed at the source when $WarningPreference is 'SilentlyContinue' or 'Ignore'. In Azure Automation runbooks the default is 'Continue' so warnings normally do reach the job output, but a runbook or a previously imported module may have overridden the preference. To make critical user-facing warnings reliable, this helper temporarily forces $WarningPreference to 'Continue' for the duration of the write. #> param( [Parameter(Mandatory = $true)] [string]$Message ) $saved = $WarningPreference $WarningPreference = 'Continue' try { Write-Warning $Message } finally { $WarningPreference = $saved } } function Resolve-RjRbImageSource { <# .SYNOPSIS Resolves an image override to bytes, content-type and filename. Used by Send-RjReportEmail to build inline Graph attachments for Header/Footer overrides. Accepts a local filesystem path that the caller has already resolved (URL handling is intentionally not part of the module). #> param( [Parameter(Mandatory = $true)] [string]$Path ) if (-not (Test-Path -LiteralPath $Path -PathType Leaf)) { throw "Image file not found: $Path" } $extension = [IO.Path]::GetExtension($Path).ToLowerInvariant() $contentType = switch ($extension) { '.png' { 'image/png' } '.jpg' { 'image/jpeg' } '.jpeg' { 'image/jpeg' } '.gif' { 'image/gif' } default { throw "Unsupported image type '$extension' for $Path. Use PNG, JPG or GIF." } } [pscustomobject]@{ Bytes = [IO.File]::ReadAllBytes($Path) ContentType = $contentType FileName = [IO.Path]::GetFileName($Path) } } function ConvertFrom-MarkdownToHtml { <# .SYNOPSIS Converts Markdown text to HTML with support for common Markdown syntax. .DESCRIPTION Lightweight Markdown to HTML converter supporting headers, lists, tables, code blocks, links, images, bold, italic, blockquotes, and horizontal rules. .PARAMETER MarkdownText The Markdown text to convert to HTML. .EXAMPLE PS C:\> ConvertFrom-MarkdownToHtml -MarkdownText "# Hello World`n`nThis is **bold** text." .OUTPUTS System.String. Returns HTML string. #> param( [Parameter(Mandatory = $true)] [AllowEmptyString()] [string]$MarkdownText ) # Input validation if ([string]::IsNullOrEmpty($MarkdownText)) { return "" } $MarkdownText = $MarkdownText.Trim() $html = $MarkdownText # Normalize line endings to \n only (remove \r) $html = $html -replace "`r`n", "`n" $html = $html -replace "`r", "`n" # Escape Markdown characters first $html = $html -replace '\\(.)', '§ESCAPED§$1§ESCAPED§' # Escaped pipes still contain '|' which breaks table-column splitting; # replace with a fully opaque placeholder before table processing. $html = $html -replace '§ESCAPED§\|§ESCAPED§', '§ESCAPEDPIPE§' # Extract and protect code blocks before processing other markdown elements # This prevents headers and other markdown syntax inside code blocks from being transformed # Store code blocks in an array and replace them with placeholders $codeBlocks = @() $codeBlockIndex = 0 # Extract code blocks with language support (handles both ``` and malformed ` variants) # Note: Some markdown content may have malformed code blocks with single backtick instead of triple backticks # (e.g., `powershell instead of ```powershell). This regex handles both cases by matching 1-3 backticks # at the start of a line (with optional indentation). $html = $html -replace '(?sm)^\s*`{1,3}(\w+)?\r?\n(.+?)^\s*`{1,3}\s*$', { $language = $_.Groups[1].Value $code = $_.Groups[2].Value.TrimEnd("`r`n").TrimEnd("`n") -replace '&', '&' -replace '<', '<' -replace '>', '>' -replace '\\`', '`' $preStyle = "background-color:#e8ebed;padding:20px;border-radius:8px;border:1px solid #e5e7eb;font-family:'SF Mono',Monaco,'Consolas',monospace;margin:20px 0;overflow-x:auto;" $preTag = if ($language) { "<pre bgcolor=`"#e8ebed`" style=`"$preStyle`"><code class=`"language-$language`" style=`"background:none;border:none;padding:0;font-family:inherit;font-size:inherit;color:#011e33;`">$code</code></pre>" } else { "<pre bgcolor=`"#e8ebed`" style=`"$preStyle`"><code style=`"background:none;border:none;padding:0;font-family:inherit;font-size:inherit;color:#011e33;`">$code</code></pre>" } # Wrap in MSO-only table to add horizontal inset in Outlook Classic # (Word engine ignores border-radius, so without this the bg fills edge-to-edge) # Use <pre> inside the td to preserve line breaks in Outlook Classic $msoCode = $code -replace "`n", "`n" $htmlBlock = "<!--[if mso]><table role=`"presentation`" width=`"100%`" cellpadding=`"0`" cellspacing=`"0`" border=`"0`" style=`"margin:20px 0;border-collapse:collapse;`"><tr><td bgcolor=`"#e8ebed`" style=`"background-color:#e8ebed;border:1px solid #e5e7eb;padding:20px;`"><pre style=`"margin:0;font-family:Consolas,'Courier New',monospace;font-size:13px;color:#011e33;white-space:pre;`">$msoCode</pre></td></tr></table><![endif]--><!--[if !mso]><!-->$preTag<!--<![endif]-->" $placeholder = "§CODEBLOCK§$codeBlockIndex§" $codeBlocks += $htmlBlock $codeBlockIndex++ return $placeholder } # Extract and protect inline code before processing other markdown $inlineCodeBlocks = @() $inlineCodeIndex = 0 $html = $html -replace '`([^`]+)`', { $code = $_.Groups[1].Value -replace '&', '&' -replace '<', '<' -replace '>', '>' -replace '\\`', '`' $htmlInline = "<code>$code</code>" $placeholder = "§INLINECODE§$inlineCodeIndex§" $inlineCodeBlocks += $htmlInline $inlineCodeIndex++ return $placeholder } # Horizontal rules - use color/size/noshade attributes for Outlook Classic $html = $html -replace '(?m)^(-{3,}|\*{3,}|_{3,})$', '<!--[if mso]><table role="presentation" width="100%" cellpadding="0" cellspacing="0" border="0" style="margin:24px 0;"><tr><td style="border-top:2px solid #e5e7eb;font-size:1px;line-height:1px;" height="1"> </td></tr></table><![endif]--><!--[if !mso]><!--><hr style="border:none;border-top:2px solid #e5e7eb;margin:24px 0;height:0;" /><!--<![endif]-->' # Headers (all 6 levels) - now safe from code block interference # Also supports headers without space after # (e.g., #Header instead of # Header) $html = $html -replace '(?m)^######\s*(.+)$', '<h6 style="color:#111827;margin-top:15px;margin-bottom:15px;font-size:16px;font-weight:800;">$1</h6>' $html = $html -replace '(?m)^#####\s*(.+)$', '<h5 style="color:#111827;margin-top:15px;margin-bottom:15px;font-size:16px;font-weight:800;">$1</h5>' $html = $html -replace '(?m)^####\s*(.+)$', '<h4 style="color:#111827;margin-top:15px;margin-bottom:15px;font-size:16px;font-weight:800;">$1</h4>' $html = $html -replace '(?m)^###\s*(.+)$', '<h3 style="color:#111827;margin-top:27px;margin-bottom:15px;font-size:18px;font-weight:800;">$1</h3>' $html = $html -replace '(?m)^##\s*(.+)$', '<h2 style="color:#111827;margin-top:42px;margin-bottom:15px;font-size:22px;font-weight:800;">$1</h2>' $html = $html -replace '(?m)^#\s*(.+)$', '<h1 style="color:#111827;border-bottom:2px solid #111827;padding-bottom:12px;margin-bottom:15px;font-size:26px;font-weight:800;">$1</h1>' # Bold and Italic (limit to single line to prevent backtracking) $html = $html -replace '\*\*([^\n\r*]+)\*\*', '<strong>$1</strong>' $html = $html -replace '\*([^\n\r*]+)\*', '<em>$1</em>' $html = $html -replace '~~([^\n\r~]+)~~', '<span style="text-decoration:line-through;">$1</span>' # Links and Images $html = $html -replace '!\[([^\]]*)\]\(([^)]+)\)', '<img src="$2" alt="$1"/>' $html = $html -replace '\[([^\]]+)\]\(([^)]+)\)', '<a href="$2" target="_blank" rel="noopener noreferrer" style="color:#3b82f6;text-decoration:underline;">$1</a>' # Helper functions function Pop-Stack { param([ref]$Stack) if ($Stack.Value.Count -gt 0) { if ($Stack.Value.Count -eq 1) { $Stack.Value = @() # Ensure it's an array } else { $Stack.Value = @($Stack.Value[0..($Stack.Value.Count - 2)]) # Ensure it's an array } } } function Update-ListNesting { param( [int]$TargetLevel, [ref]$ListStack, [ref]$ProcessedLines, [string]$ListType ) $currentLevel = $ListStack.Value.Count if ($TargetLevel -gt $currentLevel) { for ($n = $currentLevel; $n -lt $TargetLevel; $n++) { # Nested lists: no top/bottom margin to prevent extra spacing in Outlook New $nestedStyle = if ($ListType -eq 'ul') { 'style="margin:0;padding-left:20px;list-style-type:disc;"' } else { 'style="margin:0;padding-left:20px;list-style-type:decimal;"' } $ProcessedLines.Value += "<$ListType $nestedStyle>" $ListStack.Value += $ListType } } elseif ($TargetLevel -lt $currentLevel) { for ($n = $currentLevel; $n -gt $TargetLevel; $n--) { $closeType = $ListStack.Value[-1] $ProcessedLines.Value += "</$closeType>" Pop-Stack -Stack $ListStack } } } function Close-AllList { param( [ref]$ListStack, [ref]$ProcessedLines, [ref]$InUnorderedList, [ref]$InOrderedList ) while ($ListStack.Value.Count -gt 0) { $listType = $ListStack.Value[-1] $closeTag = "</$listType>" $ProcessedLines.Value += $closeTag Pop-Stack -Stack $ListStack } $InUnorderedList.Value = $false $InOrderedList.Value = $false } # Single-pass line processing $lines = $html -split "`n" $processedLines = @() $lineCount = $lines.Count $inTable = $false $inUnorderedList = $false $inOrderedList = $false $inBlockquote = $false # Task list items render as rows of a borderless presentation table # rather than <li>s, because Word (Outlook Classic) always paints the # marker of the parent <ul> regardless of `list-style:none`. $inTaskTable = $false $tableAlignments = @() $listStack = @() $tableRowIndex = 0 # Index into $processedLines of the most recent <li>. Used to fold # continuation lines (indented non-list text below a list item) back # into that <li> instead of starting a new paragraph outside the list. $lastListItemIndex = -1 for ($i = 0; $i -lt $lineCount; $i++) { $line = $lines[$i] # Blockquote processing if ($line -match '^>\s*(.*)$') { if ($inTable) { $processedLines += '</tbody></table></div>'; $inTable = $false; $tableAlignments = @(); $tableRowIndex = 0 } if ($inTaskTable) { $processedLines += '</table>'; $inTaskTable = $false } Close-AllList -ListStack ([ref]$listStack) -ProcessedLines ([ref]$processedLines) -InUnorderedList ([ref]$inUnorderedList) -InOrderedList ([ref]$inOrderedList) $content = $Matches[1] if (-not $inBlockquote) { # GitHub-style admonition: first line is "[!TYPE]" alone -> render # as a coloured callout instead of a plain blockquote. Body lines # that follow are treated like normal blockquote content. $admonitionType = $null if ($content -match '^\[!(NOTE|TIP|IMPORTANT|WARNING|CAUTION)\]\s*$') { $admonitionType = $Matches[1].ToUpperInvariant() } if ($admonitionType) { $palette = switch ($admonitionType) { 'NOTE' { @{ Accent = '#3b82f6'; Title = 'Note'; Glyph = 'ⓘ' } } 'TIP' { @{ Accent = '#10b981'; Title = 'Tip'; Glyph = '💡' } } 'IMPORTANT' { @{ Accent = '#8b5cf6'; Title = 'Important'; Glyph = '❗' } } 'WARNING' { @{ Accent = '#f59e0b'; Title = 'Warning'; Glyph = '⚠' } } 'CAUTION' { @{ Accent = '#ef4444'; Title = 'Caution'; Glyph = '⛔' } } } # Same MSO/non-MSO wrapper pattern as a plain blockquote, but # no italics and a per-type accent colour on the left border. $processedLines += "<!--[if mso]><table role=`"presentation`" width=`"100%`" cellpadding=`"0`" cellspacing=`"0`" border=`"0`" style=`"margin:15px 0;`"><tr><td bgcolor=`"#e8ebed`" style=`"background-color:#e8ebed;border-left:4px solid $($palette.Accent);padding:10px 24px;color:#374151;`" valign=`"top`"><![endif]-->" $processedLines += "<!--[if !mso]><!--><blockquote style=`"border-left:4px solid $($palette.Accent);background-color:#e8ebed;padding:10px 24px;margin:15px 0;color:#374151;border-radius:0 8px 8px 0;`"><!--<![endif]-->" $processedLines += "<p style=`"margin:0 0 8px 0;font-weight:700;color:$($palette.Accent);font-size:14px;`">$($palette.Glyph) $($palette.Title)</p>" $inBlockquote = $true continue } # MSO-only table wrapper for blockquote background (Word engine ignores background-color on blockquote) # Use border-left on a single td rather than a separate narrow td (Outlook enforces min cell width) # Hide the <blockquote> from MSO so only the table renders (inline styles override !important in Word engine) $processedLines += '<!--[if mso]><table role="presentation" width="100%" cellpadding="0" cellspacing="0" border="0" style="margin:15px 0;"><tr><td bgcolor="#e8ebed" style="background-color:#e8ebed;border-left:4px solid #3b82f6;padding:0 24px;font-style:italic;color:#374151;" valign="top"><![endif]-->' $processedLines += '<!--[if !mso]><!--><blockquote style="border-left:4px solid #3b82f6;background-color:#e8ebed;padding:10px 24px;margin:15px 0;font-style:italic;color:#374151;"><!--<![endif]-->' $inBlockquote = $true } if ($content.Trim() -ne '') { $processedLines += $content } } # Table processing elseif ($line -match '^\|.*\|$') { if ($inBlockquote) { $processedLines += '<!--[if !mso]><!--></blockquote><!--<![endif]--><!--[if mso]></td></tr></table><![endif]-->'; $inBlockquote = $false } if ($inTaskTable) { $processedLines += '</table>'; $inTaskTable = $false } Close-AllList -ListStack ([ref]$listStack) -ProcessedLines ([ref]$processedLines) -InUnorderedList ([ref]$inUnorderedList) -InOrderedList ([ref]$inOrderedList) if (-not $inTable) { $processedLines += '<div class="table-wrapper" style="margin:15px 0;">' $processedLines += '<table class="table table-striped" cellpadding="0" cellspacing="0" border="0" width="100%" style="width:100%;border-collapse:collapse;background-color:white;border:1px solid #e8ebed;">' $inTable = $true $tableRowIndex = 0 # Check for separator line with alignment if (($i + 1) -lt $lineCount -and $lines[$i + 1] -match '^\|[-:\s\|]+\|$') { $separatorLine = $lines[$i + 1] $alignmentCells = ($separatorLine -replace '^\|', '' -replace '\|$', '').Split('|') $tableAlignments = @() foreach ($alignCell in $alignmentCells) { $alignCell = $alignCell.Trim() if ($alignCell -match '^:.*:$') { $tableAlignments += 'center' } elseif ($alignCell -match ':$') { $tableAlignments += 'right' } elseif ($alignCell -match '^:') { $tableAlignments += 'left' } else { $tableAlignments += '' } } # Process header row $cells = ($line -replace '^\|', '' -replace '\|$', '').Split('|') if ($cells.Count -gt 0) { $processedLines += '<thead><tr bgcolor="#f8842c" style="background-color:#f8842c;">' for ($j = 0; $j -lt $cells.Count; $j++) { $cleanCell = $cells[$j].Trim() if ([string]::IsNullOrWhiteSpace($cleanCell)) { $cleanCell = ' ' } $alignClass = if ($j -lt $tableAlignments.Count -and $tableAlignments[$j]) { " class=`"text-$($tableAlignments[$j])`"" } else { "" } $processedLines += "<th$alignClass style=`"background-color:#f8842c;color:#ffffff;padding:8px 16px;font-weight:600;font-size:14px;`">$cleanCell</th>" } $processedLines += '</tr></thead><tbody>' $i++ continue } } } # Regular table row $cells = ($line -replace '^\|', '' -replace '\|$', '').Split('|') if ($cells.Count -gt 0) { $tableRowIndex++ $rowBgAttr = if ($tableRowIndex % 2 -eq 0) { ' bgcolor="#e8ebed" style="background-color:#e8ebed;"' } else { '' } $processedLines += "<tr$rowBgAttr>" for ($j = 0; $j -lt $cells.Count; $j++) { $cleanCell = $cells[$j].Trim() if ([string]::IsNullOrWhiteSpace($cleanCell)) { $cleanCell = ' ' } $alignStyle = if ($j -lt $tableAlignments.Count -and $tableAlignments[$j]) { "text-align:$($tableAlignments[$j]);" } else { "" } $alignClass = if ($j -lt $tableAlignments.Count -and $tableAlignments[$j]) { " class=`"text-$($tableAlignments[$j])`"" } else { "" } $processedLines += "<td$alignClass style=`"padding:8px 16px;border-bottom:1px solid #e8ebed;font-size:14px;color:#2D3748;${alignStyle}`">$cleanCell</td>" } $processedLines += '</tr>' } } # Unordered List processing elseif ($line -match '^(\s*)- (.+)$') { $indentation = $Matches[1].Length $content = $Matches[2] $nestLevel = [Math]::Floor($indentation / 2) # GitHub-style task list: "- [ ] todo" / "- [x] done". Detect before # any further -match calls (the automatic $Matches gets clobbered). $isTask = $false $taskChecked = $false if ($content -match '^\[([ xX])\]\s+(.+)$') { $marker = $Matches[1] $content = $Matches[2] $isTask = $true $taskChecked = ($marker -eq 'x' -or $marker -eq 'X') } if ($isTask) { # Tasks live in their own borderless <table> so there is no # parent <ul> for Word to draw a marker on. Close anything # else that is open first. if ($inBlockquote) { $processedLines += '<!--[if !mso]><!--></blockquote><!--<![endif]--><!--[if mso]></td></tr></table><![endif]-->'; $inBlockquote = $false } if ($inTable) { $processedLines += '</tbody></table></div>'; $inTable = $false; $tableAlignments = @(); $tableRowIndex = 0 } Close-AllList -ListStack ([ref]$listStack) -ProcessedLines ([ref]$processedLines) -InUnorderedList ([ref]$inUnorderedList) -InOrderedList ([ref]$inOrderedList) if (-not $inTaskTable) { # margin-left:20px lines the glyph column up with the # bullets of a regular <ul> (which also start ~20px in # from the content edge in both Outlook clients). # border-collapse + explicit border:0 on every cell is # required - Outlook New otherwise paints faint default # cell borders even with border="0" on the table. $processedLines += '<table role="presentation" cellpadding="0" cellspacing="0" border="0" style="margin:15px 0 12px 20px;border-collapse:collapse;border:0;background:transparent;">' $inTaskTable = $true } # Unicode ballot box glyphs render reliably across Outlook # Classic/New, OWA and mobile clients; <input type="checkbox"> # does not (Word engine strips form controls). # # Cell content is wrapped in <p style="margin:0"> because the # Word renderer (Outlook Classic) injects its own paragraph # with default top/bottom margins around bare text in a <td>, # which inflates the row height noticeably. $glyph = if ($taskChecked) { '☑' } else { '☐' } $glyphColor = if ($taskChecked) { '#10b981' } else { '#6b7280' } $processedLines += "<tr><td valign=`"top`" style=`"padding:2px 8px 2px 0;border:0;background:transparent;color:$glyphColor;font-weight:700;line-height:1.5;font-size:16px;`"><p style=`"margin:0;padding:0;`">$glyph</p></td><td valign=`"top`" style=`"padding:2px 0;border:0;background:transparent;line-height:1.5;color:#011e33;font-size:16px;`"><p style=`"margin:0;padding:0;`">$content</p></td></tr>" $lastListItemIndex = $processedLines.Count - 1 continue } if ($inBlockquote) { $processedLines += '<!--[if !mso]><!--></blockquote><!--<![endif]--><!--[if mso]></td></tr></table><![endif]-->'; $inBlockquote = $false } if ($inTable) { $processedLines += '</tbody></table></div>'; $inTable = $false; $tableAlignments = @(); $tableRowIndex = 0 } if ($inTaskTable) { $processedLines += '</table>'; $inTaskTable = $false } if ($inOrderedList) { $processedLines += '</ol>'; $inOrderedList = $false } # Open first list if needed if (-not $inUnorderedList) { $processedLines += '<ul style="margin:15px 0 12px 0;padding-left:40px;list-style-type:disc;">' $inUnorderedList = $true $listStack += 'ul' } # Handle nesting (nestLevel+1 because nestLevel is 0-based, only update if different) $targetLevel = $nestLevel + 1 if ($targetLevel -ne $listStack.Count) { Update-ListNesting -TargetLevel $targetLevel -ListStack ([ref]$listStack) -ProcessedLines ([ref]$processedLines) -ListType 'ul' } $processedLines += "<li style=`"margin:4px 0;padding-left:8px;line-height:1.5;color:#011e33;`">$content</li>" $lastListItemIndex = $processedLines.Count - 1 } # Ordered List processing elseif ($line -match '^(\s*)(\d+)\. (.+)$') { if ($inBlockquote) { $processedLines += '<!--[if !mso]><!--></blockquote><!--<![endif]--><!--[if mso]></td></tr></table><![endif]-->'; $inBlockquote = $false } if ($inTable) { $processedLines += '</tbody></table></div>'; $inTable = $false; $tableAlignments = @(); $tableRowIndex = 0 } if ($inTaskTable) { $processedLines += '</table>'; $inTaskTable = $false } if ($inUnorderedList) { $processedLines += '</ul>'; $inUnorderedList = $false } $indentation = $Matches[1].Length $content = $Matches[3] $nestLevel = [Math]::Floor($indentation / 2) # Open first list if needed if (-not $inOrderedList) { # padding-left:40px (instead of 20px) pushes the numbers # back into the content area in Outlook New / web renderers, # where the default negative marker offset would otherwise let # the digits drift left of the heading column. $processedLines += '<ol style="margin:15px 0 12px 0;padding-left:40px;list-style-type:decimal;">' $inOrderedList = $true $listStack += 'ol' } # Handle nesting (nestLevel+1 because nestLevel is 0-based, only update if different) $targetLevel = $nestLevel + 1 if ($targetLevel -ne $listStack.Count) { Update-ListNesting -TargetLevel $targetLevel -ListStack ([ref]$listStack) -ProcessedLines ([ref]$processedLines) -ListType 'ol' } $processedLines += "<li style=`"margin:4px 0;padding-left:8px;line-height:1.5;color:#011e33;`">$content</li>" $lastListItemIndex = $processedLines.Count - 1 } # Other lines else { # Continuation of the previous list item: an indented, non-empty line # directly below an open <li> belongs to that item, not to a new # paragraph outside the list. Append with a <br> and skip the rest # of the else branch so the list state is preserved. if (($listStack.Count -gt 0 -or $inTaskTable) -and $lastListItemIndex -ge 0 -and -not [string]::IsNullOrWhiteSpace($line) -and $line -match '^\s+\S' -and $line -notmatch '^<h[1-6]') { $existing = $processedLines[$lastListItemIndex] if ($existing -match '^(.*)</li>$') { $processedLines[$lastListItemIndex] = "$($Matches[1])<br>$($line.Trim())</li>" continue } # Task-table row: fold continuation into the trailing <td> # before the closing </p></td></tr>. if ($existing -match '^(.*)</p></td></tr>$') { $processedLines[$lastListItemIndex] = "$($Matches[1])<br>$($line.Trim())</p></td></tr>" continue } } if ($inBlockquote) { $processedLines += '<!--[if !mso]><!--></blockquote><!--<![endif]--><!--[if mso]></td></tr></table><![endif]-->'; $inBlockquote = $false } if ($inTable) { $processedLines += '</tbody></table></div>'; $inTable = $false; $tableAlignments = @(); $tableRowIndex = 0 } $isHeader = $line -match '^<h[1-6]>' $isEmptyLine = [string]::IsNullOrWhiteSpace($line) $nextLineIsList = $false $nextLineIsHeader = $false if ($isEmptyLine -and ($i + 1) -lt $lineCount) { for ($j = $i + 1; $j -lt $lineCount; $j++) { $nextLine = $lines[$j] if (-not [string]::IsNullOrWhiteSpace($nextLine)) { $nextLineIsList = ($nextLine -match '^(\s*)- (.+)$') -or ($nextLine -match '^(\s*)(\d+)\. (.+)$') $nextLineIsHeader = ($nextLine -match '^<h[1-6]>') break } } } if ($listStack.Count -gt 0 -and ($isHeader -or ($isEmptyLine -and -not $nextLineIsList -and -not $nextLineIsHeader))) { Close-AllList -ListStack ([ref]$listStack) -ProcessedLines ([ref]$processedLines) -InUnorderedList ([ref]$inUnorderedList) -InOrderedList ([ref]$inOrderedList) } if ($inTaskTable -and ($isHeader -or ($isEmptyLine -and -not $nextLineIsList -and -not $nextLineIsHeader))) { $processedLines += '</table>' $inTaskTable = $false } if (-not $isEmptyLine -or $listStack.Count -eq 0) { $processedLines += $line } } } # Close remaining open structures if ($inBlockquote) { $processedLines += '<!--[if !mso]><!--></blockquote><!--<![endif]--><!--[if mso]></td></tr></table><![endif]-->' } if ($inTable) { $processedLines += '</tbody></table></div>' } if ($inTaskTable) { $processedLines += '</table>' } Close-AllList -ListStack ([ref]$listStack) -ProcessedLines ([ref]$processedLines) -InUnorderedList ([ref]$inUnorderedList) -InOrderedList ([ref]$inOrderedList) $html = $processedLines -join "`n" # Paragraph processing $blocks = $html -split "`n`n+" $result = @() foreach ($block in $blocks) { $block = $block.Trim() if ($block -eq "") { continue } # Check if block starts with an HTML element tag (opening or closing) if ($block -match "^<(h[1-6]|ul|ol|table|pre|blockquote|hr)[\s>]" -or $block -match "^</(h[1-6]|ul|ol|table|pre|blockquote)>" -or $block -match '§CODEBLOCK§') { $result += $block } # Check if it contains HTML list elements - if so, don't wrap elseif ($block -match "<(h[1-6]|ul|ol|li|table|thead|tbody|tr|td|th|pre|code|blockquote|hr|/ul|/ol)[\s>]") { $result += $block } else { $lines = $block -split "`n" $nonEmptyLines = @($lines | Where-Object { $_.Trim() -ne "" }) if ($nonEmptyLines.Count -gt 0) { $paragraphContent = $nonEmptyLines -join '<br>' $result += "<p style=`"color:#111827;font-size:16px;line-height:1.4;margin-bottom:15px;`">$paragraphContent</p>" } } } $html = $result -join "`n`n" # Final safety escaping $html = $html -replace '&(?![a-zA-Z]{2,8};)(?!#[0-9]{1,7};)(?!#x[0-9a-fA-F]{1,6};)', '&' # Restore escaped Markdown characters $html = $html -replace '§ESCAPEDPIPE§', '|' $html = $html -replace '§ESCAPED§(.{1})§ESCAPED§', '$1' # Restore inline code blocks from placeholders for ($i = 0; $i -lt $inlineCodeBlocks.Count; $i++) { $html = $html -replace "§INLINECODE§$i§", $inlineCodeBlocks[$i] } # Restore code blocks from placeholders for ($i = 0; $i -lt $codeBlocks.Count; $i++) { $html = $html -replace "§CODEBLOCK§$i§", $codeBlocks[$i] } return $html } function Get-RjReportEmailBody { <# .SYNOPSIS Builds the RealmJoin-branded HTML email body used for report delivery. .DESCRIPTION Assembles the static HTML template, injects the converted Markdown content, and renders optional attachment metadata as well as tenant information into the footer section. .PARAMETER Subject Subject of the email, used for the HTML <title> element. .PARAMETER HtmlContent HTML fragment generated from Markdown that will be embedded in the email body. .PARAMETER Attachments Optional list of attachment file paths to surface in the "Attached Files" section. .PARAMETER TenantDisplayName Optional tenant display name shown in the tenant information box. .PARAMETER ReportVersion Optional report version string rendered in the tenant information box. .OUTPUTS System.String. Returns the composed HTML email body. #> param( [Parameter(Mandatory = $true)] [string]$Subject, [Parameter(Mandatory = $true)] [string]$HtmlContent, [string[]]$Attachments = @(), [string]$TenantDisplayName, [string]$ReportVersion, [switch]$IncludeHeader, [switch]$IncludeFooter, [string]$FooterLink = 'https://www.realmjoin.com' ) if (-not $Attachments) { $Attachments = @() } return @" <!DOCTYPE html> <html lang="en" xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="color-scheme" content="light dark"> <meta name="supported-color-schemes" content="light dark"> <!--[if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]--> <title>$Subject</title> <!--[if !mso]><!--> <link href="https://fonts.googleapis.com/css2?family=Miriam+Libre:wght@400;700&display=swap" rel="stylesheet"> <!--<![endif]--> <!-- Base styles for ALL clients (including Dark Mode for modern clients) --> <style type="text/css"> /* === RESET & BASICS === */ * { margin: 0; padding: 0; box-sizing: border-box; } body { font-family: 'Miriam Libre', -apple-system, BlinkMacSystemFont, 'Segoe UI', Arial, sans-serif; line-height: 1.6; color: #011e33; background-color: #e8ebed; padding: 20px; } /* === CONTAINER === */ .email-container { max-width: 750px; margin: 0 auto; background-color: #ffffff; border-radius: 12px; box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.1); overflow: hidden; } /* === HEADER === */ .header { display: block; line-height: 0; font-size: 0; } .header img.header-img { display: block; width: 100%; max-width: 750px; height: auto; border: 0; outline: none; text-decoration: none; } /* === CONTENT === */ .content { padding: 48px; background-color: #ffffff; } .tenant-info { background: #e8ebed; border: 1px solid #e0e7ff; border-left: 4px solid #f8842c; padding: 10px 20px; margin-top: 32px; border-radius: 8px; font-size: 14px; } .tenant-info strong { color: #011e33; font-weight: 600; } .content h1 { color: #111827; border-bottom: 2px solid #111827; padding-bottom: 12px; margin-bottom: 15px; font-size: 26px; line-height: 1.4; font-weight: 800; } .content h2 { color: #111827; margin-top: 42px; margin-bottom: 15px; font-size: 22px; line-height: 1.4; font-weight: 800; } .content h3 { color: #111827; margin-top: 27px; margin-bottom: 15px; font-size: 18px; line-height: 1.4; font-weight: 800; } .content h4, .content h5 { color: #111827; margin-top: 15px; margin-bottom: 15px; font-size: 16px; line-height: 1.4; font-weight: 800; } .content p { color: #111827; font-size: 16px; line-height: 1.4; margin-bottom: 15px; } .content ul { margin-top: 15px; margin-left: 0; margin-bottom: 12px; list-style-type: disc; padding-left: 20px; } .content ol { margin-top: 15px; margin-left: 0; margin-bottom: 12px; list-style-type: decimal; padding-left: 20px; } .content li { margin-top: 4px; margin-left: 0; color: #011e33; line-height: 1.5; margin-bottom: 4px; padding-left: 8px; } /* === TABLES === */ .table-wrapper { overflow-x: auto; -webkit-overflow-scrolling: touch; margin: 15px 0; } .content table { width: 100%; border-collapse: collapse; margin: 0; background-color: white; border-radius: 8px; overflow: hidden; box-shadow: 0 1px 3px 0 rgba(0, 0, 0, 0.1); } .content th { background: #f8842c !important; color: #ffffff !important; padding: 8px 16px; text-align: left; font-weight: 600; font-size: 14px; text-transform: uppercase; } .content td { padding: 8px 16px; border-bottom: 1px solid #e8ebed; font-size: 14px; color: #2D3748; } .content .text-center { text-align: center !important; } .content .text-right { text-align: right !important; } .content .text-left { text-align: left; } .content tr:nth-child(even) { background-color: #e8ebed; } .content blockquote { border-left: 4px solid #3b82f6; background: #e8ebed; padding: 20px 24px; margin-top: 15px; margin-bottom: 15px; border-radius: 0 8px 8px 0; font-style: italic; color: #374151; } /* Fix spacing after blockquote */ .content blockquote + p { margin-top: 15px !important; } /* === CODE === */ .content code { background-color: #e8ebed; padding: 2px 8px; border-radius: 4px; font-family: 'SF Mono', Monaco, 'Consolas', monospace; font-size: 0.875em; color: #011e33; border: 1px solid #e5e7eb; } .content pre { background-color: #e8ebed; padding: 20px; border-radius: 8px; overflow-x: auto; margin: 20px 0; border: 1px solid #e5e7eb; font-family: 'SF Mono', Monaco, 'Consolas', monospace; } /* === HR (Horizontal Rule) === */ .content hr { border: none; border-top: 2px solid #e5e7eb; margin: 24px 0; } /* === STRONG & EM === */ .content strong { font-weight: 600; color: #111827; } .content em { font-style: italic; color: #374151; } /* === LINKS === */ .content a { color: #3b82f6; text-decoration: underline; } .content a:hover { color: #2563eb; } /* === ATTACHMENTS === */ .attachments { background: #e8ebed; border: 1px solid #e0e7ff; border-left: 4px solid #f8842c; border-radius: 8px; padding: 10px 20px; margin-top: 10px; } .attachments h3 { color: #011e33; margin-top: 0; font-size: 14px; font-weight: 600; } .attachment-list { margin: 0 0 16px 0; padding: 0; } .attachment-item { background-color: white; border: 1px solid #e0e7ff; border-radius: 6px; padding: 8px 12px; margin-bottom: 3px; font-size: 14px; } .attachments p { margin-bottom: 0; font-size: 14px; } /* === FOOTER === */ /* Footer mirrors the header: a single self-contained graphic referenced via cid:footer in an inline image element, optionally wrapped in an anchor so the whole block is clickable. No CSS/HTML background-image on the cell - that would trigger Outlook's "external pictures" prompt even when the CID is attached. */ .footer { display: block; line-height: 0; font-size: 0; } .footer a { display: block; border: 0; outline: none; text-decoration: none; } .footer img.footer-img { display: block; width: 100%; max-width: 750px; height: auto; border: 0; outline: none; text-decoration: none; } @media (max-width: 768px) { body { padding: 10px; } .email-container { max-width: 100%; border-radius: 8px; } .content { padding: 24px 20px; } .content h1 { font-size: 20px; line-height: 1.4; } .content h2 { font-size: 18px; line-height: 1.4; } .content h3 { font-size: 16px; line-height: 1.4; } .content h4, .content h5 { font-size: 16px; line-height: 1.4; } .content p { font-size: 16px; line-height: 1.4; } .table-wrapper { margin: 15px 0; } .content table { font-size: 14px; min-width: 500px; } .content th, .content td { padding: 6px 8px; } .tenant-info, .attachments { padding: 16px 20px; font-size: 13px; } } /* === TABLET === */ @media (min-width: 769px) and (max-width: 1024px) { .email-container { max-width: 750px; } .content { padding: 36px; } } /* === DESKTOP === */ @media (min-width: 1025px) { .email-container { max-width: 750px; } } /* === DARK MODE (Outlook Classic Win32 only) === Outlook Classic ignores @media (prefers-color-scheme) and instead auto-inverts light backgrounds at render time, annotating the inverted elements with the proprietary attributes [data-ogsb] (background) and [data-ogsc] (color). Outlook New / OWA / Apple Mail / Gmail do NOT set these attributes — they use the prefers-color-scheme block below. So these selectors target Outlook Classic Dark Mode exclusively, without affecting any other client. !important is required because Outlook's inversion writes inline style attributes onto the element that would otherwise win on specificity. Colors mirror the prefers-color-scheme block so Classic and New look identical. For these selectors to match, the target element must carry an INLINE background-color (or bgcolor attribute) in the source — Outlook only injects data-ogsb where it actually inverted an explicit inline value. That is why body / .email-container / .content carry inline bgcolor/background-color below. */ body[data-ogsb] { background-color: #1a1a1a !important; } .email-container[data-ogsb], .content[data-ogsb] { background-color: #2d2d2d !important; } .tenant-info[data-ogsb], .attachments[data-ogsb] { background-color: #2d2d2d !important; border-color: #4a4a4a !important; } .attachment-item[data-ogsb] { background-color: #2d2d2d !important; border-color: #4a4a4a !important; } .content table[data-ogsb] { background-color: #3a3a3a !important; } .content tr[data-ogsb]:nth-child(even) { background-color: #404040 !important; } .content code[data-ogsb], .content pre[data-ogsb] { background-color: #404040 !important; border-color: #4a4a4a !important; } /* === DARK MODE (New Outlook, modern clients) === */ @media (prefers-color-scheme: dark) { body { background-color: #1a1a1a !important; } .email-container, .content { background-color: #2d2d2d !important; color: #e5e5e5 !important; } /* Header image keeps its native rendering in dark mode (image already has dark background). */ h1, h2, h3, p, span, strong, div, li, td, blockquote { color: #e5e5e5 !important; } h1 { border-bottom: 2px solid #e5e5e5 !important; } .tenant-info { background: linear-gradient(135deg, #2d2d2d 0%, #3a3a3a 100%) !important; border: 1px solid #4a4a4a !important; border-left-color: #f8842c !important; } .content table { background-color: #3a3a3a !important; } .content td { border-bottom-color: #4a4a4a !important; } .content th { background: #f8842c !important; color: #ffffff !important; } .content tr:nth-child(even) { background-color: #404040 !important; } .attachments { background: linear-gradient(135deg, #2d2d2d 0%, #3a3a3a 100%) !important; border: 1px solid #4a4a4a !important; border-left-color: #f8842c !important; } .attachment-item { background-color: #2d2d2d !important; border-color: #4a4a4a !important; } .content code, .content pre { background-color: #404040 !important; color: #e5e5e5 !important; border-color: #4a4a4a !important; } .content blockquote { background: linear-gradient(135deg, #2d2d2d 0%, #3a3a3a 100%) !important; border-left-color: #f8842c !important; } } </style> <!-- Outlook Classic Fixes (only for MSO) --> <!--[if mso]> <style type="text/css"> /* Force Light Mode for Outlook Classic */ body { background-color: #e8ebed; } .email-container { background-color: #ffffff; width: 750px; } .content { background-color: #ffffff; mso-padding-alt: 48px; } /* MSO Font Fallback - Outlook Classic cannot load Google Fonts */ body, p, li, td, th, h1, h2, h3, h4, h5, h6, div, span, a, blockquote { font-family: 'Segoe UI', Arial, Helvetica, sans-serif !important; } /* MSO Table Fixes */ table { mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; } /* MSO Line Height Fix */ .content p, .content li, .content td, .content th { mso-line-height-rule: exactly; line-height: 1.6; } /* MSO Heading Spacing - Word engine uses its own spacing without these */ h1 { mso-margin-top-alt: 0; mso-margin-bottom-alt: 15px; mso-line-height-rule: exactly; } h2 { mso-margin-top-alt: 42px; mso-margin-bottom-alt: 15px; mso-line-height-rule: exactly; } h3 { mso-margin-top-alt: 27px; mso-margin-bottom-alt: 15px; mso-line-height-rule: exactly; } h4, h5, h6 { mso-margin-top-alt: 15px; mso-margin-bottom-alt: 15px; mso-line-height-rule: exactly; } /* MSO Paragraph Spacing */ p { mso-margin-top-alt: 0; mso-margin-bottom-alt: 15px; } /* MSO Container Width Fix */ .email-container { width: 750px !important; } /* MSO tenant-info / attachments box - table wrapper handles styling, suppress on div */ .tenant-info, .attachments { border: none !important; border-left: none !important; background-color: transparent !important; background: transparent !important; padding: 0 !important; margin: 0 !important; } /* MSO Blockquote - table wrapper handles the border-left, suppress on blockquote itself */ blockquote { border-left: none !important; background-color: transparent !important; padding: 0 !important; margin: 0 !important; } /* MSO List Fixes - Use standard specificity */ .content ul { list-style-type: disc; margin-left: 0; padding-left: 20px; } .content ol { list-style-type: decimal; margin-left: 0; padding-left: 20px; } .content li { margin-left: 0; padding-left: 8px; mso-list: l0 level1 lfo1; } /* MSO HR Fix */ hr { mso-line-height-rule: exactly; height: 0; } </style> <![endif]--> </head> <body> <!--[if mso]> <v:background xmlns:v="urn:schemas-microsoft-com:vml" fill="t"> <v:fill type="tile" color="#e8ebed"/> </v:background> <![endif]--> <!--[if mso]> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="750" align="center" style="width:750px;border-collapse:collapse;"> <tr> <td style="background-color:#ffffff;border:1px solid #d1d5db;"> <![endif]--> <div class="email-container"> $(if ($IncludeHeader) { @' <div class="header"> <img class="header-img" src="cid:header" alt="RealmJoin – Insights on Demand" width="750" height="200" /> </div> '@ }) <div class="content"> <!--[if mso]> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"> <tr> <td style="padding:48px;"> <![endif]--> $($HtmlContent) <!--[if mso]> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="margin-top:32px;border-collapse:collapse;"><tr> <td bgcolor="#e8ebed" style="background-color:#e8ebed;border-left:4px solid #f8842c;padding:6px 20px;font-size:14px;" valign="top"> <![endif]--> <!--[if !mso]><!--> <div class="tenant-info" style="background:#e8ebed;border:1px solid #e0e7ff;border-left:4px solid #f8842c;padding:10px 20px;border-radius:8px;font-size:14px;margin-top:32px;"> <!--<![endif]--> <p style="margin:0;padding:0;mso-line-height-rule:exactly;"> <strong>Tenant:</strong> $($TenantDisplayName)<br> <strong>Generated:</strong> $([System.Threading.Thread]::CurrentThread.CurrentCulture = 'en-US'; Get-Date -Format "dddd, MMMM d, yyyy HH:mm") <br> <strong>Report Version:</strong> $($ReportVersion) </p> <!--[if !mso]><!--> </div> <!--<![endif]--> <!--[if mso]> </td></tr></table> <![endif]--> $(if (@($Attachments).Count -gt 0) { @" <!--[if mso]> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td style="font-size:1px;line-height:16px;height:16px;"> </td></tr></table> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse:collapse;"><tr> <td bgcolor="#e8ebed" style="background-color:#e8ebed;border-left:4px solid #f8842c;padding:6px 20px;font-size:14px;" valign="top"> <![endif]--> <!--[if !mso]><!--> <div class="attachments" style="background:#e8ebed;border:1px solid #e0e7ff;border-left:4px solid #f8842c;border-radius:8px;padding:10px 20px;margin-top:16px;"> <!--<![endif]--> <h3 style="margin:0 0 6px 0;padding:0;mso-margin-top-alt:0;mso-margin-bottom-alt:6px;">Attached Files</h3> <div class="attachment-list"> $(($Attachments | ForEach-Object { "<div class='attachment-item' style='background-color:white;border:1px solid #e0e7ff;border-radius:6px;padding:8px 12px;margin-bottom:3px;font-size:14px;'>$(Split-Path $_ -Leaf)</div>" }) -join "`n ") </div> <p><strong>Note:</strong> The attachments contain additional information from the generated report and can be used for more in-depth analysis.</p> <!--[if !mso]><!--> </div> <!--<![endif]--> <!--[if mso]> </td></tr></table> <![endif]--> "@ }) <!--[if mso]> </td> </tr> </table> <![endif]--> </div> $(if ($IncludeFooter) { @" <!--[if mso]> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td style="font-size:1px;line-height:24px;height:24px;"> </td></tr></table> <![endif]--> <!--[if !mso]><!--><div style="height:24px;line-height:24px;font-size:1px;"> </div><!--<![endif]--> <div class="footer"> <a href="$FooterLink" target="_blank" title="Visit $FooterLink" style="display:block;border:0;outline:none;text-decoration:none;"> <img class="footer-img" src="cid:footer" alt="RealmJoin - Companion to Intune - Application Lifecycle and Management Automation Platform - Visit $FooterLink" width="750" height="200" border="0" style="display:block;width:100%;max-width:750px;height:auto;border:0;outline:none;text-decoration:none;" /> </a> </div> "@ }) </div> <!--[if mso]> </td> </tr> </table> <![endif]--> </body> </html> "@ } function Get-MimeTypeFromExtension { <# .SYNOPSIS Returns the MIME type for a given file extension. .DESCRIPTION Maps common file extensions used for tenant data exports to their appropriate MIME types. Supports CSV, Excel, JSON, XML, TXT, and other common formats. .PARAMETER FilePath The file path to determine the MIME type for. .EXAMPLE PS C:\> Get-MimeTypeFromExtension -FilePath "C:\temp\report.csv" Returns: text/csv .EXAMPLE PS C:\> Get-MimeTypeFromExtension -FilePath "C:\temp\data.xlsx" Returns: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet .OUTPUTS System.String. Returns the MIME type string. #> param( [Parameter(Mandatory = $true)] [string]$FilePath ) $extension = [System.IO.Path]::GetExtension($FilePath).ToLower() $mimeTypes = @{ '.csv' = 'text/csv' '.txt' = 'text/plain' '.json' = 'application/json' '.xml' = 'application/xml' '.xlsx' = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' '.xls' = 'application/vnd.ms-excel' '.pdf' = 'application/pdf' '.zip' = 'application/zip' '.html' = 'text/html' '.htm' = 'text/html' '.log' = 'text/plain' '.md' = 'text/markdown' } if ($mimeTypes.ContainsKey($extension)) { return $mimeTypes[$extension] } else { # Default to binary stream for unknown types return 'application/octet-stream' } } function Send-RjReportEmail { <# .SYNOPSIS Sends a RealmJoin-branded HTML email (converted from Markdown) via Microsoft Graph. .DESCRIPTION Send-RjReportEmail builds an HTML email from Markdown content, inlines a RealmJoin-styled HTML template (including light/dark logos), attaches optional files, and sends the message using the Microsoft Graph API (Invoke-MgGraphRequest). .PARAMETER EmailFrom The sender user id (user principal name or id) used for the Graph /users/{id}/sendMail call. .PARAMETER EmailTo Recipient email address(es). Can be a single address or multiple comma-separated addresses (string). The function sends individual emails to each recipient for privacy reasons. Whitespace and empty entries are automatically removed. .PARAMETER Subject Subject line for the email message. .PARAMETER MarkdownContent Report content in Markdown format. The function performs a lightweight conversion of Markdown to HTML and places the result into the themed HTML template used for the email body. .PARAMETER Attachments Optional array of file paths to include as attachments. Files that exist will be read, base64-encoded and included as file attachments. Missing files are logged and skipped. .PARAMETER TenantDisplayName Optional display name for the tenant/organization that will be shown in the email footer and tenant info box. .PARAMETER ReportVersion Optional string describing the report version. Will be shown in the tenant-info block. .PARAMETER HeaderImage Optional local filesystem path to a PNG/JPG/GIF that overrides the bundled default header graphic. The runbook is responsible for resolving any URL/blob beforehand (e.g. via Get-AzStorageBlobContent) and passing the resulting local file path. If the path is missing, unreadable, or has an unsupported extension, a warning is written and the bundled default header is used instead - the send is not aborted. Recommended dimensions: 750x200 px PNG (matches the email-container width and the bundled default). Larger images scale down responsively; significantly different aspect ratios may look distorted on narrow viewports. .PARAMETER FooterImage Optional local filesystem path that overrides the bundled default footer graphic. Same handling and fallback behaviour as -HeaderImage. The footer is rendered as a single <img> wrapped in <a href="https://www.realmjoin.com">, so the whole graphic is the clickable target. Any branding text, logo, or URL hint you want in the footer must already be baked into the supplied PNG (see Tests/Build-FooterAsset.ps1 for how the bundled default is composed). Recommended dimensions: 750x200 px PNG (same as -HeaderImage). .PARAMETER FooterLink Optional URL that overrides the hyperlink wrapping the footer image. Defaults to 'https://www.realmjoin.com'. The supplied value is used verbatim as the href and title attributes of the footer anchor element. .PARAMETER NoHeader Suppress the header graphic entirely. .PARAMETER NoFooter Suppress the footer graphic and the overlay tagline/links entirely. .PARAMETER UseNativeGraphRequest Send the message via the native Microsoft.Graph cmdlet Invoke-MgGraphRequest instead of the module's Invoke-RjRbRestMethodGraph wrapper. The wrapper remains the default; use this switch in environments where Invoke-MgGraphRequest is preferred (e.g. when the caller has authenticated via Connect-MgGraph rather than Connect-RjRbGraph). .EXAMPLE PS C:\> Send-RjReportEmail -EmailFrom "reports@contoso.com" -EmailTo "alice@contoso.com" -Subject "Weekly Report" -MarkdownContent "# Hello`nReport body..." .EXAMPLE PS C:\> Send-RjReportEmail -EmailFrom "reports@contoso.com" -EmailTo "alice@contoso.com, bob@contoso.com, team@contoso.com" -Subject "Inventory" -MarkdownContent (Get-Content .\report.md -Raw) -Attachments @('C:\temp\report.csv') -TenantDisplayName 'Contoso Ltd' -ReportVersion 'v1.2.3' .INPUTS None. All parameters are provided as arguments; this function does not accept pipeline input. .OUTPUTS None. The function sends email and writes verbose/log messages. On failure it throws an exception. .NOTES Dependencies: - Default path (recommended): uses the module's own Invoke-RjRbRestMethodGraph / Connect-RjRbGraph and has no external module dependency. - Optional path with -UseNativeGraphRequest: requires the Microsoft.Graph.Authentication module to be available in the runbook environment (cmdlets Get-MgContext, Connect-MgGraph, Invoke-MgGraphRequest). Declare it explicitly in the consuming runbook, e.g.: #Requires -Modules @{ModuleName = "Microsoft.Graph.Authentication"; ModuleVersion = "2.0.0"} #> param( [Parameter(Mandatory = $true)] [string]$EmailFrom, [Parameter(Mandatory = $true)] [string]$EmailTo, [Parameter(Mandatory = $true)] [string]$Subject, [Parameter(Mandatory = $true)] [string]$MarkdownContent, [string[]]$Attachments = @(), [bool]$saveToSentItems = $true, [string]$TenantDisplayName, [string]$ReportVersion, # Override paths are NOT strictly validated at parameter binding so that a # missing/unreadable override falls back to the bundled default instead of # aborting the whole send. Resolve errors are caught below. [string]$HeaderImage, [string]$FooterImage, [string]$FooterLink = 'https://www.realmjoin.com', [switch]$NoHeader, [switch]$NoFooter, [switch]$UseNativeGraphRequest ) # Parse and clean email addresses from EmailTo parameter # Split by comma, trim whitespace, remove empty entries # Important: Wrap in @() to ensure we always get an array (StrictMode-friendly) $emailRecipients = @( $EmailTo -split ',' | ForEach-Object { $_.Trim() } | Where-Object { $_ -ne '' } ) if ($emailRecipients.Count -eq 0) { throw "No valid email recipients found in EmailTo parameter." } Write-RjRbLog -Message "Parsed $($emailRecipients.Count) recipient(s) from EmailTo parameter" -Verbose # Convert Markdown to HTML using helper function $htmlContent = ConvertFrom-MarkdownToHtml -MarkdownText $MarkdownContent Write-RjRbLog -Message "Successfully converted Markdown content to HTML" -Verbose # Prepare email parameters $emailAttachments = @() $validatedAttachments = @() foreach ($file in $Attachments) { if (Test-Path $file) { try { $contentBytes = [IO.File]::ReadAllBytes($file) $content = [Convert]::ToBase64String($contentBytes) $mimeType = Get-MimeTypeFromExtension -FilePath $file $emailAttachments += @{ "@odata.type" = "#microsoft.graph.fileAttachment" "name" = (Split-Path $file -Leaf) "contentType" = $mimeType "contentBytes" = $content } $validatedAttachments += $file Write-RjRbLog -Message "Added attachment: $(Split-Path $file -Leaf) (MIME type: $mimeType)" -Verbose } catch { Write-RjRbForcedWarning -Message "Could not read attachment '$file': $($_.Exception.Message). Skipping." Write-RjRbLog -Message "Attachment read failed for '$file': $($_.Exception.Message)" -Verbose } } else { Write-RjRbLog -Message "Attachment file not found: $file" -Verbose } } # --- Inline branding images (CID attachments) --- # Graph treats inline images as regular fileAttachment entries with isInline=true # and a stable contentId that the HTML references via <img src="cid:..."> / # background:url('cid:...'). PNG/JPG is preferred for cross-client rendering # (Outlook Classic does not render SVG reliably). $includeHeader = -not $NoHeader.IsPresent $includeFooter = -not $NoFooter.IsPresent if ($NoHeader.IsPresent -and $HeaderImage) { Write-RjRbForcedWarning -Message "HeaderImage was provided but will be ignored because -NoHeader is set." } if ($NoFooter.IsPresent -and $FooterLink -ne 'https://www.realmjoin.com') { Write-RjRbForcedWarning -Message "FooterLink was provided but will be ignored because -NoFooter is set." } if ($NoFooter.IsPresent -and $FooterImage) { Write-RjRbForcedWarning -Message "FooterImage was provided but will be ignored because -NoFooter is set." } if ($includeHeader) { $headerBytes = $null $headerContentType = $null $headerFileName = $null if ($HeaderImage) { try { $headerAsset = Resolve-RjRbImageSource -Path $HeaderImage $headerBytes = $headerAsset.Bytes $headerContentType = $headerAsset.ContentType $headerFileName = $headerAsset.FileName } catch { Write-RjRbForcedWarning -Message ("Could not load custom HeaderImage from '$HeaderImage'. " + "Underlying error: $($_.Exception.Message). " + "Falling back to the bundled default header graphic.") Write-RjRbLog -Message "HeaderImage override failed for '$HeaderImage' - underlying error: $($_.Exception.Message)" -Verbose } } if (-not $headerBytes) { if ($script:RjRbDefaultHeaderBytes) { $headerBytes = $script:RjRbDefaultHeaderBytes $headerContentType = 'image/png' $headerFileName = 'Header.png' } else { Write-RjRbLog -Message "Default header asset not found at $script:RjRbDefaultHeaderPath - skipping header graphic" -Verbose $includeHeader = $false } } if ($includeHeader) { if ($headerBytes.Length -gt 3MB) { Write-RjRbForcedWarning -Message "Header image is $([Math]::Round($headerBytes.Length / 1MB, 2)) MB; Graph sendMail caps total request size at 4 MB." } $emailAttachments += @{ "@odata.type" = "#microsoft.graph.fileAttachment" "name" = $headerFileName "contentType" = $headerContentType "contentBytes" = [Convert]::ToBase64String($headerBytes) "contentId" = "header" "isInline" = $true } } } if ($includeFooter) { $footerBytes = $null $footerContentType = $null $footerFileName = $null if ($FooterImage) { try { $footerAsset = Resolve-RjRbImageSource -Path $FooterImage $footerBytes = $footerAsset.Bytes $footerContentType = $footerAsset.ContentType $footerFileName = $footerAsset.FileName } catch { Write-RjRbForcedWarning -Message ("Could not load custom FooterImage from '$FooterImage'. " + "Underlying error: $($_.Exception.Message). " + "Falling back to the bundled default footer graphic.") Write-RjRbLog -Message "FooterImage override failed for '$FooterImage' - underlying error: $($_.Exception.Message)" -Verbose } } if (-not $footerBytes) { if ($script:RjRbDefaultFooterBytes) { $footerBytes = $script:RjRbDefaultFooterBytes $footerContentType = 'image/png' $footerFileName = 'Footer.png' } else { Write-RjRbLog -Message "Default footer asset not found at $script:RjRbDefaultFooterPath - skipping footer graphic" -Verbose $includeFooter = $false } } if ($includeFooter) { if ($footerBytes.Length -gt 3MB) { Write-RjRbForcedWarning -Message "Footer image is $([Math]::Round($footerBytes.Length / 1MB, 2)) MB; Graph sendMail caps total request size at 4 MB." } $emailAttachments += @{ "@odata.type" = "#microsoft.graph.fileAttachment" "name" = $footerFileName "contentType" = $footerContentType "contentBytes" = [Convert]::ToBase64String($footerBytes) "contentId" = "footer" "isInline" = $true } } } $htmlBody = Get-RjReportEmailBody ` -Subject $Subject ` -HtmlContent $htmlContent ` -Attachments $validatedAttachments ` -TenantDisplayName $TenantDisplayName ` -ReportVersion $ReportVersion ` -IncludeHeader:$includeHeader ` -IncludeFooter:$includeFooter ` -FooterLink $FooterLink # --- Ensure a Graph connection is active -------------------------------- # Send-RjReportEmail is typically the first/only Graph touchpoint in a # runbook, so we lazily establish a connection here if none is active. # The probe is intentionally permission-free: we only inspect local auth # state (script-scope auth headers / Get-MgContext), no network call. if ($UseNativeGraphRequest) { $mgContext = $null try { $mgContext = Get-MgContext -ErrorAction SilentlyContinue } catch { } if (-not $mgContext) { Write-RjRbLog -Message "No active Microsoft.Graph context detected - calling Connect-MgGraph -Identity -NoWelcome" -Verbose try { Connect-MgGraph -Identity -NoWelcome -ErrorAction Stop } catch { throw "Auto-connect via Connect-MgGraph -Identity failed: $($_.Exception.Message)" } } } else { if (-not (Test-Path Variable:Script:RjRbGraphAuthHeaders)) { Write-RjRbLog -Message "No active RjRbGraph token detected - calling Connect-RjRbGraph" -Verbose try { Connect-RjRbGraph -ErrorAction Stop } catch { throw "Auto-connect via Connect-RjRbGraph failed: $($_.Exception.Message)" } } } # Send individual emails to each recipient for privacy $successfulSends = 0 $failedSends = 0 $failedRecipients = @() foreach ($recipient in $emailRecipients) { try { Write-RjRbLog -Message "Sending email to: $recipient" -Verbose $message = @{ subject = $Subject body = @{ contentType = "HTML" content = $htmlBody } toRecipients = @( @{ emailAddress = @{ address = $recipient } } ) } if ($emailAttachments.Count -gt 0) { $message.attachments = $emailAttachments } # Send via Graph API $body = @{ message = $message; saveToSentItems = $saveToSentItems } if ($UseNativeGraphRequest) { # Native Graph cmdlet path: requires the caller to have an active # Microsoft.Graph session (e.g. via Connect-MgGraph). The wrapper's # JSON encoding does not run here, so we serialise the body ourselves. $Uri = "https://graph.microsoft.com/v1.0/users/$($EmailFrom)/sendMail" $jsonBody = $body | ConvertTo-Json -Depth 10 Invoke-MgGraphRequest -Uri $Uri -Method POST -Body $jsonBody -ContentType "application/json" -ErrorAction Stop } else { $Resource = "/users/$($EmailFrom)/sendMail" Invoke-RjRbRestMethodGraph -Resource $Resource -Method POST -Body $body -ErrorAction Stop } Write-RjRbLog -Message "Email sent successfully to $recipient" -Verbose $successfulSends++ } catch { $failedSends++ $failedRecipients += $recipient Write-RjRbLog -Message "Failed to send email to ${recipient}: $($_.Exception.Message)" -Verbose Write-Error "Failed to send email to ${recipient}: $($_.Exception.Message)" -ErrorAction Continue } } # Summary logging Write-RjRbLog -Message "Email sending completed: $successfulSends successful, $failedSends failed out of $($emailRecipients.Count) total recipient(s)" -Verbose if ($failedSends -gt 0) { $failedList = $failedRecipients -join ", " Write-RjRbLog -Message "Failed recipients: $failedList" -Verbose if ($successfulSends -eq 0) { throw "Failed to send email to all recipients: $failedList" } else { Write-RjRbForcedWarning -Message "Some emails failed to send. Failed recipients: $failedList" } } } |