Got a credit card? use our Credit Card & Finance Calculators
Thanks to Wasron,jfgw,Rhyd6,eyeball08,Wondergirly, for Donating to support the site
Embedding an outlook message into Excel
Forum rules
Direct questions and answers, this room is not for general discussion please
Direct questions and answers, this room is not for general discussion please
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Embedding an outlook message into Excel
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
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
-
- Lemon Half
- Posts: 6385
- Joined: November 4th, 2016, 11:35 am
- Has thanked: 1882 times
- Been thanked: 2026 times
Re: Embedding an outlook message into Excel
Could you just do a snapshot with the snipping tool and drop that into the spreadsheet?
I do it that way
I do it that way
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
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 !
-
- Lemon Half
- Posts: 6385
- Joined: November 4th, 2016, 11:35 am
- Has thanked: 1882 times
- Been thanked: 2026 times
Re: Embedding an outlook message into Excel
Highlight the email text then copy>paste or paste special
You can drop it in with source formatting, or as plain text
You can drop it in with source formatting, or as plain text
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
Ok it's clunky
Embed the msg file into Word and embed that doc in Excel
Not ideal, so still open to solutions please
Embed the msg file into Word and embed that doc in Excel
Not ideal, so still open to solutions please
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
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
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
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
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
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Embedding an outlook message into Excel
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
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
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
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
-
- Lemon Half
- Posts: 7383
- Joined: February 7th, 2017, 9:36 pm
- Has thanked: 10514 times
- Been thanked: 4659 times
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
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
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
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Embedding an outlook message into Excel
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
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
How odd
I did the same thing and it didn't work
let me try it again in a bit
I did the same thing and it didn't work
let me try it again in a bit
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
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
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
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Embedding an outlook message into Excel
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
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Embedding an outlook message into Excel
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
I see similar properties, and I"ve emailed my Excel file and opened the embedded msg on a completely separate system....
Cheers,
Itsallaguess
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Embedding an outlook message into Excel
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
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
-
- 2 Lemon pips
- Posts: 209
- Joined: February 15th, 2017, 5:49 pm
- Has thanked: 1 time
- Been thanked: 103 times
Re: Embedding an outlook message into Excel
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.
Who is online
Users browsing this forum: No registered users and 30 guests