I use the following code in a worksheet to open the latest word document in a file folder and then open it.

It takes the unconventional method after finding the file of setting it as an icon on the sheet in a cell that is hidden by a button, then opening the file from the icon, then deleting the icon. This was a work around given from another forum as the usual method of opening the file simply wouldn't work for some unknown reason.

Please Login or Register  to view this content.
Is it possible to adapt this code so that it will open email messages saved ( with .msg extension) in a filesystem folder, copy the message which may contain text, hyperlinks, photo's and pictures, and paste it into an excel sheet?

What if any objects etc will need to be present on the excel sheet for this to complete sucessfully?

Many Thanks