Solved

Excel 2010 and Outlook 2010

Posted on 2013-01-26
4
392 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

821 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