Excel & Outlook

[clappouk]

Morning All,

I have a problem with .msg outlook messages, I would like to copy the email into an excel cell so that when users are working the case they will be able to read the original data.

I have tried using copy, paste & insert object but to no avail.

I copied an email onto my desktop as a .msg file and then created a hyperlink to it within the cell, this works great but the users dont have access to my desk top and to copy 5000 messages to a folder on the network that everyone has access too would cause problems.

Any Ideas

Ray

 

[RichardMGreen]

If you can copy it to the clipboard, can't you paste it into the excel cell as text?
Not the best of solutions, but it least the information will be visible.