Solved

Excel 2010 and Outlook 2010

Posted on 2013-01-26
4
389 Views
Last Modified: 2013-01-27
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
Comment
Question by:jegajothy
  • 2
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
LifeN-Ti earned 500 total points
ID: 38823377
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
 

Author Comment

by:jegajothy
ID: 38824142
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
 

Author Closing Comment

by:jegajothy
ID: 38824145
This is the solution.  Hope the moderators could archive this for future use. Thank u.
0
 
LVL 2

Expert Comment

by:LifeN-Ti
ID: 38824178
Hey jegajothy,
Glad I could help and appreciate that! Good luck:)
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Generating a graph via Excel 3 27
Copy value from a certain cell 5 24
Excel VBA When using VLookup 6 28
Excel Hyperlink Question 4 31
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remaiā€¦
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now