Solved

Excel 2010 and Outlook 2010

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

773 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