The Lemon Fool

I need to embed an outlook message into a spreadsheet that I want to share with others
When I use 'Insert. Object' the location of the link is either the place where the msg file was saved, or the temp folder on my laptop
Is it possible to actually embed it into excel so that if I email the spreadheet to someone they will see the email (which they won't if it is looking for the file on my computer)
Thanks in advance
Paul

Could you just do a snapshot with the snipping tool and drop that into the spreadsheet?
I do it that way

AleisterCrowley wrote:Could you just do a snapshot with the snipping tool and drop that into the spreadsheet?
I do it that way

Thanks
I can do
but the person I need to send it wants to able to copy content from the email
This is annoying as it works fine with MS word !

Highlight the email text then copy>paste or paste special
You can drop it in with source formatting, or as plain text

Ok it's clunky
Embed the msg file into Word and embed that doc in Excel
Not ideal, so still open to solutions please

AleisterCrowley wrote:Highlight the email text then copy>paste or paste special
You can drop it in with source formatting, or as plain text

OK I'll give that a go as well
cheers

OK my boss doesn't want anything embedded now
but it's still a Microsoft glitch that you can embed word docs properly and not Outlook messages
Thanks for coming back to me Aleister
cheers
Paul

pje16 wrote:
OK my boss doesn't want anything embedded now

but it's still a Microsoft glitch that you can embed word docs properly and not Outlook messages

This seems to suggest that there shouldn't be a problem doing that with Excel -

How to insert or embed an Outlook message in Excel?

https://www.extendoffice.com/documents/excel/881-excel-insert-embed-email.html

Cheers,

Itsallaguess

Thanks IAAG
but you missed my point
The image location on that link is on the users Desktop, so that means ONLY they can see it, if they emailed it to say you, it wouldn't work
It will only work on their PC
cheers
Paul

https://www.youtube.com/watch?v=h7sFq1blvCc

Any use?

AiY

Hi AiY
no it's not
as with IAAG the message is located on the Desktop, so it only works for that user
You can't let another user see files that are located on someone else's PC
cheers
Paul

pje16 wrote:
Thanks IAAG
but you missed my point
The image location on that link is on the users Desktop, so that means ONLY they can see it, if they emailed it to say you, it wouldn't work
It will only work on their PC

I've just placed a msg file onto my desktop, and then embedded it into an Excel file as an object, as per the instructions on the link I gave earlier, and then saved the Excel file and then fully come out of Excel.

I've then DELETED the original msg file from my desktop

I've then opened the Excel file, and the embedded msg object is still there, and can be double-clicked on to open the msg file...

I think you're missing something in the steps you're doing...

Cheers,

Itsallaguess

How odd
I did the same thing and it didn't work
let me try it again in a bit

I tried again and here's what happens
Inserted a file from my X:drive (a network location)
I can then deleted that file and the link worked , however
Excel has copied the file to Users\Appdata\ Local\Temp folder and that's why deleting the original file leads one to believe it is embedded in Excel
It isn't though it is now in the users temp folder
You can check this by right clicking on the linked file, select Packager Shell Object Object and Properties
so we are back to the same problem

pje16 wrote:
So we are back to the same problem

Ther is no problem - it works....

Regarding the temp folder - you're overthinking things...

Cheers,

Itsallaguess

Re temp No I am not overthinking
I am in fact correct
Screenshot of Excel and temp location

And have you emailed that Excel file?

I see similar properties, and I"ve emailed my Excel file and opened the embedded msg on a completely separate system....

Cheers,

Itsallaguess

Well I am amazed and apologise
HTF does excel work then?
I copied it from my work laptop to a portable hard drive and opened it on there
and it took 30 seconds or so but then opens
and shows the temp on my Desktop where I have a different user name
I guess what Excel is showing is the "working area" not the true loctaion as it is "buried" inside the spreadsheet
Thanks IAAG, AIY and Aleister
sorry to have wasted your time
Perhaps I shouldn't have looked into how it was working and just tried it

It did exactly what you asked, and embedded the Outlook message into the Excel file. So you have an Excel document which contains, among other things, an email object. However, Outlook doesn't know how to look inside a spreadsheet to find an email to open, so when you open the email Excel extracts a copy of the email into a temporary directory and tells Outlook to open it from there.