How to embed e-mail in Excel spreadsheet?

[excel-rob]

Hi, I've embedded various files in word documents before by copying the file from explorer and then using paste special to embed the file in the word document. If I try to do the same with an e-mail .msg or .html file that I've saved from Outlook, the Paste Special option in the menu is greyed out. Can anyone tell me how to do this in excel?
Thanks for any help.

 

[nirvana_]

Hope this is what you want.

1) Save the file from Outlook onto the desktop. To do this highlight the mail and click File - Save As.

Then save the file.

2) Open Excel then goto. Insert - Object - Create from File - Browse - Choose the e-mail which you saved on the desktop.

This will insert it into the excel sheet. Re-arrange as required.

 

[jamesvtm]

in my case i wanted to embed links to email msgs in excel file.

in Outlook 2007

1. open the email msg you want to link to
2. click on "Other Actions", "View in Browser"
3. message opens in Browser, click on address, make sure entire address is selected [ctrl-A], press ctrl-C to copy.
4. switch to excel file, and select the field where you want the Hyperlink to be placed, and press ctrl-K, ctrl-V, & ENTER.

Limitation: the link points to a temporary directory on C: drive.

 

[NickKlemz]

You could use our eFiler add-in for Outlook to help you to do this as eFiler saves emails into network folders as msg files, has a very powerful search tool to help you find them again (always a plus) and also allows you to create links to these saved msg files which you could then copy and paste into your spreadsheet.

We are giving away a free seat of eFiler to anyone who asks for one (at our sole discretion) and there is a free 30 day trial of it available on our website.

Please visit http://efiler.co.uk

Nick Klemz