[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 397
  • Last Modified:

Excel 2010 and Outlook 2010

My OS is win 7 prof 64 bit and I use Excel 2010 and Outlook 2010.  

I have created a spreadsheet in Excel 2010, and in one of the cells, I would like to put a link to a specific email in a specific folder in Outlook 2010.  Can this be done?  If yes, could the experts please  let me know how it is done and the syntax.   So that if I were to click on that link, it will open up that particular email.  Thank u
0
jegajothy
Asked:
jegajothy
  • 2
  • 2
1 Solution
 
LifeN-TiCommented:
Hi,
I do not believe that's possible or at least practical as when you spread the spreadsheet around they would need to have outlook and that specific email which wouldn't work, however you can save the email as a file and attach it to the excel document to have essentially the same effect.

First to get the email saved as a file:
- Open Outlook,
- Go to the email & double click it to open it,
- At the top of the email window hit "File"then "Save As" - browse to a location you want to put the email file (which you'll then put into outlook so somewhere easy to remember like your desktop or documents), type a name for the email file, then make sure the File Type is .msg and hit Save

To insert the file into excel:
- Open Excel & the workbook you're working on,
- Click the cell you want to place the icon to open the file,
- Select the INSERT tab at the top of Excel,
- Click on the OBJECT button (see below)
(see attached screenshot for help finding the object button, I'm using Outlook 2013 but it will still be called "Object" when you put your mouse over it and it should have the same icon)
- The Insert Object window will open, select "Create from File" tab at the top,
- Select Browse and browse to, then select, the .msg email file you created with instructions above,
- Make sure "Link to File" is unchecked unless you're just going to be using this on your computer (not sending to anyone), also make sure "Display as icon" is unchecked (it'll display as icon anyway)

Then once all done you should be good, users will see the email.msg file with an icon in that cell and can double click to open it! Any issues or questions just post back!

Take care,
insert-object-example.PNG
0
 
jegajothyAuthor Commented:
In response to LifeN-T, I salute u for the solution.  It IS the  solution to a very complex Q and I would grade u at 150%, well done and thank u.  U are a credit to your Title as Guru and Expert.
0
 
jegajothyAuthor Commented:
This is the solution.  Hope the moderators could archive this for future use. Thank u.
0
 
LifeN-TiCommented:
Hey jegajothy,
Glad I could help and appreciate that! Good luck:)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now