Question:
I am using PowerShell to loop through designated folders in Outlook and saving the attachments in a tree like structure. This works wonders, but now management has requested the email itself be saved as a PDF as well. I found the PrintOut
method in object, but that prompts for a file name. I haven’t been able to figure out what to pass to it to have it automatically save to a specific filename. I looked on the MSDN page and it was a bit to high for my current level.
I am using the com object of outlook.application.
Short of saving all of the emails to a temp file and using a third party method is there parameters I can pass to PrintOut? Or another way to accomplish this?
Here is the base of the code to get the emails. I loop through $Emails
1 2 3 4 5 6 7 8 |
$Outlook = New-Object -comobject outlook.application $Connection = $Outlook.GetNamespace("MAPI") #Prompt which folder to process $Folder = $Connection.PickFolder() $Outlook_Folder_Path = ($Folder.FullFolderPath).Split("\",4)[3] $BaseFolder += $Outlook_Folder_Path + "\" $Emails = $Folder.Items |
Answer:
Looks like there are no built-in methods, but if you’re willing to use third-party binary, wkhtmltopdf can be used.
- Get precompiled binary (use MinGW 32-bit for maximum compatibility).
- Install or extract installer with 7Zip and copy
wkhtmltopdf.exe
to your script directory. It has no external dependencies and can be redistributed with your script, so you don’t have to install PDF printer on all PCs. - Use HTMLBody property of
MailItem
object in your script for PDF conversion.
Here is an example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
# Get path to wkhtmltopdf.exe $ExePath = Join-Path -Path ( Split-Path -Path $Script:MyInvocation.MyCommand.Path ) -ChildPath 'wkhtmltopdf.exe' # Set PDF path $OutFile = Join-Path -Path 'c:\path\to\emails' -ChildPath ($Email.Subject + '.pdf') # Convert HTML string to PDF file $ret = $Email.HTMLBody | & $ExePath @('--quiet', '-', $OutFile) 2>&1 # Check for errors if ($LASTEXITCODE) { Write-Error $ret } |
Please note, that I’ve no experience with Outlook and used MSDN to get relevant properties for object, so the code might need some tweaking.