?
Solved

Excel 2010 and Outlook 2010

Posted on 2013-01-26
4
Medium Priority
?
395 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
LifeN-Ti earned 2000 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

770 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