How to import .msg e-mail files from a Windows folder directly into Excel?

[Arthur Frayn]

Hi,

With my recent Windows 10 upgrade, it seems the File Explorer "preview pane" no longer works for .msg files...

I was wonder if there is a way to import the data from Outlook files in a Windows folder directly into an Excel sheet.

Basically, I would specify the path to the folder "C:/....", ask Excel to sort through the .msg files there and create and spreadsheet which looks something like this:

Column A = SENDER OF THE EMAIL
Column B = RECIPIENT
Column C = BODY OF THE EMAIL

Does anyone know a way to set that up?

Thanks!

 

[John_w]

See if you can adapt the code at https://www.mrexcel.com/forum/excel...chments-msg-file-post4803463.html#post4803463. It extracts attachments from .msg files, but could be changed to do what you want, by importing these properties into cells instead:

        outEmail.SenderEmailAddress 'or outEmail.SenderName
        outEmail.Recipients  'collection, which requires looping to get each recipient
        outEmail.Body