Convert .msg file to pdf in Power Automate Desktop

[ps_noob_to_pro]

Hi All,

Is there a very to convert .msg file to pdf, i have already tried using "OneDrive convert" activity, this does not work for me.

Please let me know if there are any different approaches.

[VishnuReddy1997]

Hi @ps_noob_to_pro ,

Please find the solution.

Code:

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''MMMM''' Result=> FormattedDateTime
Folder.GetFiles Folder: $'''C:\\Users\\OneDrive\\Desktop\\Input''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
LOOP FOREACH CurrentItem IN Files
    System.RunApplication.RunApplication ApplicationPath: CurrentItem.FullName WindowStyle: System.ProcessWindowStyle.Normal ProcessId=> AppProcessId
    WAIT 2
    MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Control}({P})''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: True
    WAIT 2
    MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{LWin}({Alt})''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: True
    WAIT 2
    MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Control}({P})''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: True
    WAIT 2
    MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Control}({P})''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: True
    WAIT 2
    MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\Text File\\%CurrentItem.NameWithoutExtension%%FormattedDateTime%.pdf{Return}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: True
END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

[Deenuji]

@ps_noob_to_pro 

Please follow the below approach:

1. Open Outlook.
2. Retrieve email messages from Outlook by applying necessary filters.
3. Save Outlook email messages based on the retrieved emails variable.
4. Lastly, execute the PowerShell script by specifying the location where the .msg file is saved.

Place the below code in powershell:

# Define the path to the .msg file
$msgFilePath = "C:\Boot\1 of your flow(s) have failed.msg"

# Define the output PDF file path
$pdfFilePath = "C:\Boot\failed.pdf"

# Start a hidden instance of Microsoft Outlook
$outlook = New-Object -ComObject Outlook.Application

# Open the .msg file
$msg = $outlook.Session.OpenSharedItem($msgFilePath)

# Use the built-in Print to PDF printer to save the message as PDF
$msg.PrintOut()
Start-Sleep -Seconds 5  # Wait for printing to finish

# Find the recently created PDF file
$pdfFile = Get-ChildItem -Path $env:USERPROFILE -Filter "*.pdf" | Sort-Object LastWriteTime -Descending | Select-Object -First 1

if ($pdfFile -eq $null) {
    Write-Host "Error: PDF file not found."
} else {
    # Move the PDF file to the desired location
    Move-Item -Path $pdfFile.FullName -Destination $pdfFilePath -Force
    Write-Host "PDF file successfully created: $pdfFilePath"
}

# Close Outlook and release resources
$msg.Close()
$outlook.Quit()
[System.Runtime.InteropServices.Marshal]::ReleaseComObject($msg) | Out-Null
[System.Runtime.InteropServices.Marshal]::ReleaseComObject($outlook) | Out-Null

# Remove any remaining temporary PDF files
Remove-Item -Path "$env:USERPROFILE\*.pdf" -Force

The above powershell script would help you to convert email message(.msg) to pdf file.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

[NathanAlvares24 · Accepted solution]

Hi @ps_noob_to_pro !

Try this flow:

the two paths: 'path' and 'path2' I had used input variables. But you can use 'Set variable' action to store the paths and then use it or simply just select or type the path in the fields for 1 and 3 actions.

Let me show you an example:

I have this file on my desktop. This is a .eml file (same as .msg). The contents are as follows:

Now when I use 'Launch Word' action for this file, the following will be opened:

Now after this step, I simply close the word doc using 'Close Word' action. (The Focus Window action is just extra) Specify the name of the path and filename to save as. Like below:

Result will be coming in pdf. Like:

Please do try it out. And let me know. I hope this helps.

[jcq35]

Hi, i know it is not directly in Power Automate but you can also use an external simple software which runs on background of your pc or server and convert your msg files in real time in PDF, take a look to Automatic Email Manager from Namtuk, it will do the job easily.

Regards,

Jean