I would like to populate an excel sheet with below details for every new email in my Outlook.
3. Reply – To
4. Return Path
5. X-Agari Original Sender
6. X-Agari Original Receiver
7. X-Originating IP
Whenever a new email comes into my outlook inbox or any other SPECIFIC folder, I need an excel sheet to be updated.
Could you please help me with this?
So far i have done this in Python but could not find proper documentation for the modules which I am using. This is the reason I had to come to Powershell as both Outlook and Powershell are from Microsoft.
Outlook isn't actually "enabled" for PowerShell. The best you're going to be able to do is Outlook's old COM object, which s exposed via .NET Interop for Office Programmability. I'd look into that – but, it's going to be difficult, and it's going to involve a LOT of code. Outlook (and Excel, for that matter) just wasn't designed for this task.