Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Embedding an outlook message into Excel

Straight answers to factual questions
Forum rules
Direct questions and answers, this room is not for general discussion please
pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Embedding an outlook message into Excel

#441807

Postby pje16 » September 13th, 2021, 10:16 am

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

AleisterCrowley
Lemon Half
Posts: 6381
Joined: November 4th, 2016, 11:35 am
Has thanked: 1880 times
Been thanked: 2026 times

Re: Embedding an outlook message into Excel

#441808

Postby AleisterCrowley » September 13th, 2021, 10:18 am

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441810

Postby pje16 » September 13th, 2021, 10:22 am

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 !

AleisterCrowley
Lemon Half
Posts: 6381
Joined: November 4th, 2016, 11:35 am
Has thanked: 1880 times
Been thanked: 2026 times

Re: Embedding an outlook message into Excel

#441814

Postby AleisterCrowley » September 13th, 2021, 10:25 am

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441816

Postby pje16 » September 13th, 2021, 10:27 am

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441818

Postby pje16 » September 13th, 2021, 10:28 am

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441840

Postby pje16 » September 13th, 2021, 11:39 am

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

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: Embedding an outlook message into Excel

#441851

Postby Itsallaguess » September 13th, 2021, 12:28 pm

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441854

Postby pje16 » September 13th, 2021, 12:34 pm

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

AsleepInYorkshire
Lemon Half
Posts: 7383
Joined: February 7th, 2017, 9:36 pm
Has thanked: 10514 times
Been thanked: 4659 times

Re: Embedding an outlook message into Excel

#441858

Postby AsleepInYorkshire » September 13th, 2021, 12:40 pm


pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441860

Postby pje16 » September 13th, 2021, 12:51 pm

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

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: Embedding an outlook message into Excel

#441865

Postby Itsallaguess » September 13th, 2021, 1:07 pm

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441872

Postby pje16 » September 13th, 2021, 1:36 pm

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441878

Postby pje16 » September 13th, 2021, 2:08 pm

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

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: Embedding an outlook message into Excel

#441889

Postby Itsallaguess » September 13th, 2021, 2:33 pm

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441896

Postby pje16 » September 13th, 2021, 2:51 pm

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

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: Embedding an outlook message into Excel

#441903

Postby Itsallaguess » September 13th, 2021, 3:10 pm

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Embedding an outlook message into Excel

#441910

Postby pje16 » September 13th, 2021, 3:30 pm

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 :roll: :roll:

SteelCamel
2 Lemon pips
Posts: 208
Joined: February 15th, 2017, 5:49 pm
Has thanked: 1 time
Been thanked: 103 times

Re: Embedding an outlook message into Excel

#442658

Postby SteelCamel » September 15th, 2021, 11:41 pm

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.


Return to “Does anyone know?”

Who is online

Users browsing this forum: No registered users and 10 guests